Microsoft SQL Server - Reset the Identity Column Sequence Number.

Here is how we reset the Identity column to start from 1 run the below query.

Syntax:

DBCC CHECKIDENT('<Table_Name>', RESEED, 0)

Example:

DBCC CHECKIDENT('Customer', RESEED, 0)

The above statement will reset the Identity column of the Customer Table to 0, so that when a new record is inserted the identity column value will be 1.

Thanks for reading my Blog !