How to reset identity column value in sql server

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 ('EmpDetail', RESEED, 0)