Reset Identity Column Value to 1 in SQL Database

DBCC CHECKIDENT (Table_Name, RESEED, New_Reseed_Value)
 
 
Table_Name is name of your identity column table
RESEED specifies that the current identity value should be changed.
New_Reseed_Value is the new value to use as the current value of the identity column.
 
EXAMPLE: DBCC CHECKIDENT ('CustomerDetails', RESEED, 0) 
Ebook Download
View all
Learn
View all