To reset identity column value and start value from “1” during insert new records we need to write query to reset identity column value. Check below Query
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.
<b>EX</b>: DBCC CHECKIDENT ('UserDetails', RESEED, 0)