check if the table exists

• issam mansour

  SSC-Addicted

  Points: 478

  More actions

  May 20, 2008 at 8:54 am

  #95936

  Hi,

  This my first time using the link server to read the files directly from within SQL2005, so issues the following link:-

  EXEC sp_addlinkedserver

  @server = N'MYVFPSERVER', -- Your linked server name here

  @srvproduct=N'Visual FoxPro 9', -- can be anything

  @provider=N'VFPOLEDB',

  @datasrc=N'"C:\PROGRAM FILES\MICROSOFT VISUAL FOXPRO 9\Samples\data\testdata.dbc"'

  After that i can open query and do the import issues, but how can check if the table exists before issues the query.

  Best regards

• SQLshifu

  SSC Eights!

  Points: 953

  More actions

  May 20, 2008 at 9:18 am

  #818017

  check in [yourdb].sys.tables to see if that table exist.

• Scalability Doug

  SSCertifiable

  Points: 5351

  More actions

  May 20, 2008 at 9:18 am

  #818018

  Two system procs:

  sp_catalogs and

  sp_tables_ex

  will give you remote catalogs and tables.

  DAB