title: Reordering Identity primary key in sql server
body: <p>Yes i am very well aware the consequences. But i just want to reorder them. Start from 1 to end.</p>
  
  <p>How do I go about reordering the keys using a single query ?</p>
  
  <p>It is clustered primary key index</p>
  
  <p>Reordering like</p>
  
  <pre><code>First record Id 1 
  second record Id 2
  </code></pre>
  
  <p>The primary key is Int</p>