sqlserver 查找某个字段在哪张表里

如何查找某个字段属于哪张表？

select [name] from [库名].[dbo].sysobjects where id in(select id from [库名].[dbo].syscolumns Where name='字段名')