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
转载于:https://www.cnblogs.com/honhwa/archive/2011/11/02/2232743.html