取 SQL 数据表主键

SELECT C.Name FROM SysColumns AS C
INNER JOIN SysObjects AS O ON C.Id = O.Id
WHERE (O.Name = 'TableName') AND (EXISTS (
    SELECT 1 FROM SysObjects WHERE (XType = 'PK') AND (Name IN (
        SELECT Name FROM SysIndexes WHERE (IndId IN (
            SELECT IndId FROM SysIndexKeys WHERE (Id = C.Id) AND (ColId = C.ColId)
        ))
    ))
))