title: Alter Existing Primary Column to Auto Increment in SQL Server
body: <p>I have a table and it already have a primary key, the data type is <code>integer</code>. The problem is the column is not set to  auto increment once a row is being inserted. I have to check the max then add 1 to manually auto increment to column. Is there a way to alter the column to set the primary key to auto increment? I'm going to add hundreds of records and adding the id manually is quite a tedious task. I cannot drop the column since there are IDs that are already existing. Thanks in advance.</p>