【原】根据字段查来源表

use tempdb;

select t1.name as [字段名称],t2.name as [表名称]
from syscolumns as t1
join sysobjects as t2 on t1.[id] = t2.[id]
where
t1.id in (select object_id(name) from sysobjects where type='U')
and t1.name = '已知的字段名称';