I hadn’t used this handy tool in sql server in a while and actually had to look it up recently, so here it is in the code review. TRUNCATE TABLE “table_name” Truncating not only deletes all of rows in the table, but it deletes all information about the table, which makes all auto numbering integer fields start over at 1. [...]