how to reset identity column in sql server management studio code example
Example 1: reset identity column in sql server
DBCC CHECKIDENT ('YourTableName', RESEED, 1)
Example 2: sql server reset identity
DBCC CHECKIDENT ('table name', RESEED , 0)