sql 已知列名找表名

[yp_zhou]

请问怎么在sql中，我已知某一个列名，但现在要查找这个列在那个数据表或那几个数据表中，要怎么写sql语句呢？

[leo_lesley]

select object_name(id) from syscolumns where [name] ='已知某一个列名'

[中国风]

use master 
go
declare Roy cursor for
select 	Name from sysdatabases  where dbid>4
declare @Data sysname
open roy
fetch next from roy into @Data
while @@fetch_status=0
begin 
	exec('use ['+@Data+'] select 數據庫='''+@Data+''',表名=a.Name from sysobjects a join syscolumns b on a.ID=b.ID and a.xtype=''U'' and b.Name=''列名''')
	fetch next from roy into @Data
end
close roy
deallocate roy