SELECT Col.Column_Name from 

    INFORMATION_SCHEMA.TABLE_CONSTRAINTS Tab, 

    INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE Col 

WHERE 

    Col.Constraint_Name = Tab.Constraint_Name

    AND Col.Table_Name = Tab.Table_Name

    AND Constraint_Type = 'PRIMARY KEY'

    AND Col.Table_Name = '<your table name>'

現在通常建議您在SQL Server中使用sys.*視圖INFORMATION_SCHEMA，因此，除非您打算遷移數據庫，否則我將使用這些視圖。使用sys.*視圖的方法如下：

SELECT 

    c.name AS column_name,

    i.name AS index_name,

    c.is_identity

FROM sys.indexes i

    inner join sys.index_columns ic  ON i.object_id = ic.object_id AND i.index_id = ic.index_id

    inner join sys.columns c ON ic.object_id = c.object_id AND c.column_id = ic.column_id

WHERE i.is_primary_key = 1

    and i.object_ID = OBJECT_ID('<schema>.<tablename>');