How to locate a table from different databases ?

• cytodex

  Old Hand

  Points: 387

  More actions

  August 30, 2002 at 2:09 pm

  #58325

  We have a 3rd party applications running on SQL-Server. It has created a series of databases with views, tables, etc. I would like to use some sp to query all databases to return me to which database a particular table is located. Thanks.

• Prakash Heda

  SSCertifiable

  Points: 5539

  More actions

  August 30, 2002 at 10:35 pm

  #435768

  select name from master..sysdatabases

  Get resultsdets in to a cusror and loop through this query...

  exec 'if object_id(''' + @db_name + '..' + @tablename + ''') is not null Print '''table exists''''

  Cheers,

  Prakash

  Prakash Heda
  Lead DBA Team - www.sqlfeatures.com
  Video sessions on Performance Tuning and SQL 2012 HA