查询包含某字段的所有表
select object_name(id) objName,Name as colName
from syscolumns
where (name like’%你要查询的字段名%’)
and id in(select id from sysobjects where xtype=‘u’)
order by objname
2020-08-23
最新推荐文章于 2021-08-15 11:02:58 发布
查询包含某字段的所有表
select object_name(id) objName,Name as colName
from syscolumns
where (name like’%你要查询的字段名%’)
and id in(select id from sysobjects where xtype=‘u’)
order by objname