how to reset auto increment in mssql code example Example: sql reset auto increment ALTER TABLE tmp AUTO_INCREMENT = 3;