Please Login to Continue

Free Software Development Articles.Email List

Advertise Here

Find Out Which Database Contain A Table

Sometimes it is very important to query the database meta-data in order to be fast and efficient. SQL code to query the System Database metadata to find out which database has a table you are looking for is simply below:

SQL code

Select * from sys.databases
  WHEN state_desc = 'ONLINE' 
  THEN OBJECT_ID(QUOTENAME(name) + '.[dbo].[PutTheNameOfTable]', 'U')

Technology published
Buy Me Coffee

Was this page helpful?

Yes Yes! this solution to the problem was helpful. No No! this solution to the problem was not helpful..

© 2020 - ErnesTech - Privacy