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 SYSOBJECTS B

ON A.ID=B.PARENT_OBJ

AND A.XTYPE='U' AND B.XTYPE='PK'

and A.NAME in ('s_MortgageServiceProc')

-- 方法三：

EXEC sp_pkeys @table_name='k_ProblemClass'