SELECT B.NAME AS TABLENAME,A.NAME AS COLUMNNAME
FROM SYSCOLUMNS A
INNER JOIN SYSOBJECTS B ON A.ID=B.ID
WHERE B.TYPE='U'
AND A.NAME LIKE '% XXX %'
查找数据库中某一列名
最新推荐文章于 2023-04-19 17:04:18 发布
SELECT B.NAME AS TABLENAME,A.NAME AS COLUMNNAME
FROM SYSCOLUMNS A
INNER JOIN SYSOBJECTS B ON A.ID=B.ID
WHERE B.TYPE='U'
AND A.NAME LIKE '% XXX %'