title: Enable Collation on Primary Key column in sql server 2012
body: <p>I have a table in sql server 2012 where there is a column that is part of the Primary key. It has a collation set <code>SQL_Latin1_General_CP1_CI_AS</code> on it. As part of requirement , I need this column to be case-sensitive for which I need to alter the column collation to <code>SQL_Latin1_General_CP1_CS_AS</code> as follows:</p>
  
  <pre><code>ALTER TABLE &lt;Table_Name&gt;
  ALTER COLUMN &lt;Col Name&gt; &lt;Data Type&gt;
  COLLATE SQL_Latin1_General_CP1_CS_AS
  </code></pre>
  
  <p>As I understand I cannot alter collation on primary key column. Hence , I removed the column from primary key cluster , executed the above Alter collation command and made the column primary key back again. Unfortunately though after executing the alter command the collation changed to <code>SQL_Latin1_General_CP1_CS_AS</code> , it flipped back to <code>SQL_Latin1_General_CP1_CS_AS</code> after I made that column as a primary key.</p>
  
  <p>Would Appreciate if anyone could help me understand why this is occurring?</p>