SQL SERVER查看表中是否有主键约束的三种方法
-- 方法一:
SELECT
TABLE_NAME,COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME = 's_MortgageServiceProc'
-- 方法二:
SELECT A.NAME AS 表名,B.NAME AS 主键名
FROM SYSOBJECTS A
JOIN SYSOBJ...
原创
2019-05-10 10:47:00 ·
5173 阅读 ·
1 评论