SQL TRUNCATE vs DELETE
Using the TRUNCATE TABLE command is faster and consumes less memory than using the DELETE TABLE command.
TRUNCATE TABLE is not used with WHERE Clause but DELETE TABLE command can be used with WHERE clause.
SQL TRUNCATE TABLE
SQL TRUNCATE TABLE command deletes all the records in a table while preserving the table structure.