sql server 查询数据库中包含某字段的所有的表:
select object_name(id) objName,Name as colName
from syscolumns
where (name like'%DeptID%')
and id in(select id from sysobjects where xtype='u')
order by objname
查出来有两列:objNmae为表名,colName为列名
sql server 查询数据库中包含某字段的所有的表:
select object_name(id) objName,Name as colName
from syscolumns
where (name like'%DeptID%')
and id in(select id from sysobjects where xtype='u')
order by objname
查出来有两列:objNmae为表名,colName为列名