SELECT b.name AS 表名,a.name AS 列名
FROM sys.columns a
JOIN sys.tables b ON a.object_id=b.object_id
WHERE UPPER(a.name) LIKE UPPER('%关键字%')
SQL查看关键字是否是某表中列名
最新推荐文章于 2024-09-27 13:42:26 发布
SELECT b.name AS 表名,a.name AS 列名
FROM sys.columns a
JOIN sys.tables b ON a.object_id=b.object_id
WHERE UPPER(a.name) LIKE UPPER('%关键字%')