Sql Server根据表名查询该表所属数据库
EXEC sp_MSforeachdb @command1
= 'IF EXISTS( SELECT Name FROM [?].SYS.OBJECTS WHERE CharIndex(''consi'', Name) > 0)
PRINT ''?'''
EXEC sp_MSforeachdb @command1
= 'IF EXISTS( SELECT Name FROM [?].SYS.OBJECTS WHERE CharIndex(''consi'', Name) > 0)
PRINT ''?'''