查出表的主键及主键列

SELECT t.name			AS tableName,
       i.name			AS pkName,
       STUFF((SELECT ',' + c.name
              FROM   sys.sysindexkeys AS s2
              INNER JOIN sys.[columns] AS c
              ON  c.column_id = s2.colid
              AND c.[object_id] = t.[object_id]
              AND s2.indid = i.index_id
              AND s2.id = t.[object_id] FOR XML PATH('')
           ),1,1,'' )	AS pkColumnNames
FROM   sys.tables  AS t
       INNER JOIN sys.indexes i
            ON  t.[object_id] = i.[object_id]
       INNER JOIN sys.stats s
            ON  i.object_id = s.object_id
            AND i.index_id = s.stats_id
            AND i.is_primary_key = 1
--WHERE t.[object_id]=OBJECT_ID('表名')