查寻某个字段在存在哪张表里

2012-07-24

查找某个字段在存在哪张表里select a.Name as tableName from sysobjects a inner join syscolumns b on a

查找某个字段在存在哪张表里
select a.Name as tableName from sysobjects a inner join syscolumns b on a.ID=b.ID
where b.Name='字段名'