Delete table data and reset the automatically numbered column truncate table

Truncate table

 

 

The truncate table function is the same as the delete statement without the WHERE clause: both delete all rows in the table. However, truncate table is faster than delete and uses less system and transaction log resources.
The delete statement deletes a row at a time and records one row in the transaction log. Truncate table deletes data by releasing the data pages used to store table data, and only records the release of pages in transaction logs.
Truncate table deletes all rows in the table, but the table structure, its columns, constraints, and indexes remain unchanged. The Count value used by the new row ID is reset to the seed of the column.
To retain the ID Count value, use Delete instead.
To delete table definitions and data, use the drop TABLE statement.