<p>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.</p>

The system stored procedure
```
sp_help
```
will give you the information. Execute the following statement:
```
```
execute sp_help table_name
```
```