Query to reset Identity Column
DBCC CHECKIDENT ('Table_Name', RESEED, 0)
Note : Table_Name is the table name in which identity to be reset.
Query to reset Identity Column
DBCC CHECKIDENT ('Table_Name', RESEED, 0)
Note : Table_Name is the table name in which identity to be reset.