title: Convert an existing Column to Identity
body: <p>I have a table in SQL Server with bundle of records. I want to convert the ID column which is Primary Key to an identity Column without loss of data. I thought of the following two approaches: </p>
  
  <ol>
  <li>Create a new table with identity &amp; drop the existing table.</li>
  <li>Create a new column with identity &amp; drop the existing column.</li>
  </ol>
  
  <p>but it's clear that they can not be implemented because keeping records is my first priority.</p>
  
  <p>Is there another way to do this?</p>