Here's another way from the question [get table primary key using sql query][Get Primary Key]:



<pre><code>SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE OBJECTPROPERTY(OBJECT_ID(CONSTRAINT_SCHEMA+'.'+CONSTRAINT_NAME), 'IsPrimaryKey') = 1
  AND TABLE_NAME = '<i>&lt;your table name&gt;</i>'
</code></pre>

It uses [`KEY_COLUMN_USAGE`][KEY_COLUMN_USAGE] to determine the constraints for a given table  
Then uses [<code>OBJECTPROPERTY(<i>id</i>, 'IsPrimaryKey')</code>][OBJECTPROPERTY] to determine if each is a primary key


[KEY_COLUMN_USAGE]: http://msdn.microsoft.com/en-us/library/ms189789.aspx

[OBJECTPROPERTY]: http://msdn.microsoft.com/en-us/library/ms176105.aspx
[Get Primary Key]: https://stackoverflow.com/q/3930338/1366033

Simple question, how do you list the primary key of a table with T-SQL? I know how to get indexes on a table, but can't remember how to get the PK.

How do you list the primary key of a SQL Server table?

Answer