TRUNCATE

TRUNCATE Statement

Removes all rows from a table but unlike DELETE, it is not transactional and cannot be rolled back.

TRUNCATE TABLE employees;

Faster than DELETE for removing all rows and resets storage space.