use 数据库名
go
select a.Name as tableName
from sysobjects a
inner join syscolumns b on a.ID=b.ID
where b.Name='列名'
sqlserver中查找某个字段名存在于哪个表中
最新推荐文章于 2022-08-16 10:59:56 发布
use 数据库名
go
select a.Name as tableName
from sysobjects a
inner join syscolumns b on a.ID=b.ID
where b.Name='列名'