title: Determine a table's primary key using TSQL
body: <p>I'd like to determine the primary key of a table using TSQL (stored procedure or system table is fine). Is there such a mechanism in SQL Server (2005 or 2008)?</p>