查询某字段在哪些表里

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