title: SQL Server Change Primary Key Data Type
body: <p>I am working on <code>SQL Server 2012</code>:</p>
  
  <p>I have a table with a primary key column as <code>INT</code>. I need to change this to a <strong>GUID</strong>.</p>
  
  <p>Do I alter the table and remove int column as <code>primary key</code>?</p>
  
  <p>Add the <strong>GUID</strong> column and set it as Primary and drop the old INT column?</p>
  
  <p>Thank you.</p>