need a list of tables on a linked server

• Alan Stott

  SSC-Addicted

  Points: 436

  More actions

  April 22, 2003 at 4:34 am

  #159097

  Hi everyone,

  I am trying to see if a table exists on a linked server, I have tried using the INFORMATION_SCHEMA.TABLES view but the path needs to be fully qualified (FQP) and therefore I can only get the master DB's tables. I have also tried using the FQP with the OBJECT_ID() function but had no success there either. IF EXISTS (SELECT * FROM FQP )works fine if you have rows in the table, however this will not always be the case.

  I know I can go to the root of the INF_SCHEMA.TABLES view and use the sysobjects table but I am really not happy with this solution as this code is for use in a COTS product.

  Any ideas folks?

• Antares686

  SSC Guru

  Points: 125444

  More actions

  April 22, 2003 at 5:12 am

  #454879

  Take a look at

  sp_tables_ex

  in SQL BOL.

• Alan Stott

  SSC-Addicted

  Points: 436

  More actions

  April 22, 2003 at 5:58 am

  #454885

  Thanks, that does the job nicely.