When we delete data from a database table in SQL Sever, we want the ID to start again at 1 instead of the command that follows the last ID.

First, if the data is important, please back up the data

Second, delete the data in the table

Sql:delete from (' Table name ')

such as: Delete from ABCD

Third, execute the new statement

SQL:DBCC checkident (' table name ', reseed,0)

such as: DBCC CHECKIDENT (' ABCD ', reseed,0)

Note:

{

DBCC checkident (' table_name ', reseed, New_reseed_value)

Checks the current identity value of the specified table and, if necessary, corrects the identity value.

}

Once this is done, the newly inserted data ID will start at 1.

Http://jingyan.baidu.com/article/020278118f65e11bcd9ce542.html

When we delete data from a database table in SQL Sever, we want the ID to start again at 1 instead of the command that follows the last ID.