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.