查询字段所在的表/视图

/*
查询字段所在的表/视图
*/
select a.name as 表名 from sysobjects as a left join syscolumns as b on a.id=b.id where b.name='字段名'