This article is tagged with:
Sql server reset auto increment
and mysql
sql reset auto increment
ALTER TABLE tmp AUTO_INCREMENT = 3;
sql server reset auto increment
DBCC CHECKIDENT (mytable, RESEED, 0)