title: Add a IDENTITY to a column in SQL SERVER 2008
body: <pre><code>create table stud(
  Student_Id int primary key,
  Student_Name varchar(30),
  Student_surname varchar(12),
  Student_Initial varchar(10))
  </code></pre>
  
  <p>I had created a table stud. Now i want to add Identity to Student_Id column using alter query</p>
  
  <pre><code>alter table stud alter column student_Id int identity   
  </code></pre>
  
  <p>I get error as </p>
  
  <p>Incorrect syntax near the keyword 'identity'.</p>