Using TRUNCATE
The TRUNCATE statement allows us to delete all the rows from a table. For example:
TRUNCATE TABLE employee;
This query would delete all the employees from the employee table. This is faster than a DELETE statement because it works by dropping the table and re-creating it empty. One thing to bear in mind is that TRUNCATE is not transaction safe.
| 
