how to reset auto increment id in sql server code example
Example 1: sql reset auto increment
ALTER TABLE tmp AUTO_INCREMENT = 3;
Example 2: sql server reset auto increment
DBCC CHECKIDENT (mytable, RESEED, 0)
ALTER TABLE tmp AUTO_INCREMENT = 3;
DBCC CHECKIDENT (mytable, RESEED, 0)