查询指定的表在那些数据库中存在-数据库专栏,SQL Server

–查询指定的表在那些数据库中存在

declare @tbname sysname
set @tbname=客户资料

declare @dbname sysname,@sql nvarchar(4000),@re bit,@sql1 varchar(8000)
set @sql1=
declare tb cursor for select name from master..sysdatabases
open tb
fetch next from tb into @dbname
while @@fetch_status=0
begin
 set @sql=set @re=case when exists(select 1 from [
  +@dbname+]..sysobjects where xtype=u and name=
  +@tbname+) then 1 else 0 end
 exec sp_executesql @sql,n@re bit out,@re out
 if @re=1 set @sql1=@sql1+ union all select +@dbname+
 fetch next from tb into @dbname
end
close tb
deallocate tb
set @sql1=substring(@sql1,12,8000)
exec(@sql1)