I will explain to change identity column seed value in SQL server or reseed identity column seed value of table in SQL server or how to change identity column value in SQL server. DBCC CHECKIDENT (Table_Name, RESEED, New_Reseed_Value) Table_Name is name of your identity column table