title: How to Alter a table for Identity Specification is identity SQL Server
body: <hr>
  
  <p>not working </p>
  
  <pre><code>ALTER TABLE ProductInProduct ALTER COLUMN Id KEY IDENTITY (1, 1);
  </code></pre>
  
  <p>Check Image</p>
  
  <p>I have a table ProductInProduct is want its id should be Unique.. <img src="https://i.stack.imgur.com/NwDrd.png" alt="enter image description here"></p>