Reset the auto-increment column of SQL Server

Reset the field value of the ID columnFor example, DBCC checkident (tablename, reseed, 1); sets the ID seed of tablename to 1.

 

The following is an explanation of msdn:

DBCC checkident
(
Table_name
[, {Noreseed | {reseed [, new_reseed_value]}]
)
[With no_infomsgs]

Parameters

Table_name

Is the name of the table whose current identity value is to be checked. The specified table must contain an ID column. The table name must comply with the identifier rules.

Noreseed

Specifies that the current ID value should not be changed.

Reseed

Specifies that the current ID value should be changed.

New_reseed_value

The new value used to identify the current value of the column.

With no_infomsgs

Undisplay all information messages.