However, the SQL TRUNCATE statement cannot be used with a WHERE clause and it cannot be rolled back. Third, it can affect the performance and integrity of your database if you do not use it properly.

The `TRUNCATE` statement removes all data from the table in a non-transactional way. `TRUNCATE` can be thought of as semantically the same as `DROP TABLE` + `CREATE TABLE` with the previous definition ...