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) 
X

Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

Start Learning Now