SQL TRUNCATE clause


Example

Use this to reset the table to the condition at which it was created. This deletes all rows and resets values such as auto-increment. It also doesn't log each individual row deletion.

TRUNCATE TABLE Employees