title: How do I determine if a column is in the primary key of its table? (SQL Server)
body: <p>I am currently using...</p>
  
  <pre><code>select Table_Name, Column_name, data_type, is_Nullable
  from information_Schema.Columns
  </code></pre>
  
  <p>...to determine information about columns in a given database for the purposes of generating a DataAccess Layer.</p>
  
  <p><strong>From where can I retrieve information about if these columns are participants in the primary key of their table?</strong></p>