To find a SQL Server object, such as a user table, query the
sysobjects system table in the local database.
If the database name is unknown, use the following query:
Exec sp_MSforeachdb
'Select * From ?..sysobjects where name like 'objectname'''
The
? in the query is replaced with the database names, internally—or for example, you could do this for a table
license:
Exec sp_MSforeachdb
'if exists(select * from ?..sysobjects where name =
''license'') select * from ?..sysobjects where name = ''license'' '
This will return all the information in that table.
