title: Alter table column for primary key and identity
body: <p>I have table created and want to alter that table. I want to add a primary key and <code>identity(1,1)</code>.</p>
  
  <p>I can apply primary key but applying identity gives error. Is anything missing?</p>
  
  <pre><code>ALTER TABLE MyTable ADD PRIMARY KEY (Id)
  </code></pre>
  
  <p>How can I add identity as well with primary key?</p>