SQL server根据表名查询表主键

SQL server根据表名查询表主键

SELECT o.name AS 表名
    ,c.name AS 主键列名
    ,k.colid AS 字段序号
    ,k.keyno AS 索引顺序
FROM sysindexes i
INNER JOIN sysindexkeys k ON i.id = k.id
    AND i.indid = k.indid
INNER JOIN sysobjects o ON i.id = o.id
INNER JOIN syscolumns c ON i.id = c.id
    AND k.colid = c.colid
WHERE o.xtype = 'U'
    AND EXISTS (
        SELECT 1
        FROM sysobjects
        WHERE xtype = 'PK'
            AND name = i.name
        )
    AND o.name = 'TJ_MZYW' --表名称
ORDER BY o.name
    ,k.colid

本作品采用《CC 协议》，转载必须注明作者和本文链接