sql-server - How to find database name of any table

Question

How to find the database name for a particular table when we have created a table and we forgot the database where we have created the same.

标签： sql-server

Answer 1

试试这个 EXEC sp_MSforeachdb

EXEC sp_MSforeachdb 'USE ? SELECT sc.TABLE_CATALOG, sc.TABLE_SCHEMA, sc.TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS  sc WHERE TABLE_NAME=''YourTableName'''