SELECT a.name, c.name FROM sysobjects a INNER JOIN syscolumns c ON ( a.id = c.id )WHERE c.name LIKE '%FID%'ORDER BY a.name asc
查询MSSQL 数据库中所有包含某个字段的 表、存取过程
最新推荐文章于 2023-01-07 09:09:16 发布
SELECT a.name, c.name FROM sysobjects a INNER JOIN syscolumns c ON ( a.id = c.id )WHERE c.name LIKE '%FID%'ORDER BY a.name asc