title: How to determine the primary key for a table in SQL Server?
body: <p>What I'd like to be able to do in SQL Server 2005 somehow is with a table name as input determine all the fields that make up the primary key. <code>sp_columns</code> doesn't seem to have this field. Any ideas as to where to look?</p>