mssql-auto-increment

inf: http://stackoverflow.com/questions/10991894/auto-increment-primary-key-in-sql-server-management-studio-2012

ALTER TABLE [yourTable] DROP COLUMN ID 
ALTER TABLE [yourTable] ADD ID INT IDENTITY(1,1)