-- 方法一:
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'