使用SQL取得表的Primary Key(主键)

SELECT s4.name,s3.keyno FROM sys.sysobjects s
INNER JOIN sys.sysindexes s2 ON s.id = s2.id AND (s2.status=2066 OR s2.status = 2050)
INNER JOIN sys.sysindexkeys s3 ON s2.id = s3.id AND s2.indid = s3.indid
INNER JOIN sys.syscolumns s4 ON s3.id = s4.id AND s3.colid = s4.colid
WHERE s.name ='mvsrecord' ORDER BY s3.keyno