根据字段名查找其所属的表

select * from dbo.sysobjects
where
id in (select id from dbo.syscolumns  where name = '字段名)