How to reset initial increment id value in SQL Server

Question

I would like to have a nice template for this in development. How to reset initial value of increment identifier in SQL Server?

Answer 1

DBCC CHECKIDENT('TableName', RESEED, 0) 

Answer 2

Just a warning word with:

 DBCC CHECKIDENT (MyTable, RESEED, 0) 

If you did not truncate the table, and the identification column is a PC, you will receive an error message when reaching previously existing identifiers.

For example, you already have identifiers (3,4,5) in the table. Then you specify the reset column with identifier 1. After entering identifier 2, the next insert will try to use identifier 3, which will not be executed.

Answer 3

To establish identity 100:

 DBCC CHECKIDENT (MyTable, RESEED, 100)