SQL查询数据库中表存在于哪个库

DECLARE @BSNAME VARCHAR(500)
DECLARE @Sql_content VARCHAR(8000)

DECLARE cur CURSOR FOR SELECT name FROM sys.databases FOR READ ONLY
OPEN cur
FETCH NEXT FROM cur INTO @BSNAME

WHILE @@FETCH_STATUS = 0
BEGIN
--必须先读一行才能进来，否则无法进来

SET @Sql_content ='IF(EXISTS(SELECT top 1 1 FROM '+@BSNAME+'.sys.tables WHERE name=''PW_EleJobTitleAssignment'')) print '''+@BSNAME+''''
EXEC (@Sql_content)
--执行完上面步骤才能读取下一个数据
FETCH NEXT FROM cur INTO @BSNAME

END
CLOSE cur
DEALLOCATE cur