How to alter column to identity(1,1)This topic has 0 replies, 1 voice, and was last updated 11 years, 5 months ago by Ankur.Viewing 1 post (of 1 total)AuthorPosts December 23, 2011 at 11:45 am #3246 AnkurMemberYou can’t alter the existing columns for identity.There are two methods which you can use to Alter Column as Identity-1. Create a new table with identity & drop the existing table2. Create a new column with identity & drop the existing columnif your table is not blank then before drop the table you need to first copy data in temp table. AuthorPosts Viewing 1 post (of 1 total) You must be logged in to reply to this topic.Log In Username: Password: Keep me signed inLog In