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')

Was this page helpful?

Yes Yes! this solution to the problem was helpful. No No! this solution to the problem was not helpful.. Leave ErnesTech Feedback.Feedback
Login to Continue

Community of Software Developers

Welcome, log in to continue reading. It's free and only takes a minute.

© 2020 - ErnesTech - Privacy