--包含SortSourceName字段的视图
select a.Name as tableName
from sysobjects a
inner join
syscolumns b on a.ID=b.ID
where b.Name='SortSourceName' and a.Name like 'view%'--包含v的表名
SQL查找包含某字段的视图\表
最新推荐文章于 2023-01-11 17:14:43 发布
--包含SortSourceName字段的视图
select a.Name as tableName
from sysobjects a
inner join
syscolumns b on a.ID=b.ID
where b.Name='SortSourceName' and a.Name like 'view%'--包含v的表名