Reset Identity Column seed value in SQL

Here, I would like to describe how to reset the identity column seed value.

Step 1: Create table:

 

CREATE TABLE tablename

( ID INT IDENTITY(1001,1) NOT NULL,

dateofInsertion DATETIME NOT NULL )

 

Step 2: Insert the record in the Table using this statement.

 

INSERT INTO tablename(dateofInsertion) VALUES(GETDATE()),(GETDATE()),(GETDATE()),(GETDATE()),(GETDATE())

 

Result is like this:

 

Step 3: Now, if you want to reset the identity seed value of the existing table,

then write an SQL statement such as given below.

 

DBCC CHECKIDENT (tablename, reseed, 200000) 

 

Step 4:  Again insert a new record in this table using this SQL statement.

 INSERT INTO tablename(dateofInsertion) VALUES(GETDATE()),(GETDATE()),(GETDATE()),(GETDATE()),(GETDATE())

 

Step 4: After Resetting the identity value of the existing table, the result looks like this:

 

 

Thanks..........