获取所有包含指定字段的所有表
with t1 as(
Select Name as TblName,Object_Id(Name)TblObjId FROM SysObjects Where XType='U'
),t2 as(
select a.*,b.name as ColName from t1 a join SysColumns b on b.name='你要查的字段名' and a.TblObjId=b.id
)
select * from t2
order by TblName
with t1 as(
Select Name as TblName,Object_Id(Name)TblObjId FROM SysObjects Where XType='U'
),t2 as(
select a.*,b.name as ColName from t1 a join SysColumns b on b.name='你要查的字段名' and a.TblObjId=b.id
)
select * from t2
order by TblName
