Reset Identity column in SQL Server

2009-04-17


For identity column in SQL Server, we have a command to easy to control it!

DBCC CHECKIDENT

1 : Resets the Identity value for the Customer table to 0 so that the next record added starts at 1.

** DBCC CHECKIDENT('Customer', RESEED, 0)**

2: Check current identify value:

**DBCC CHECKIDENT ('tablename', NORESEED)**

3: Set the next ID start from 1000:

**DBCC CHECKIDENT (****'tablename'****, RESEED, 999)**