What are the key differences between the DELETE and TRUNCATE SQL commands?

SQL Server - Interview Questions

The main differences between the DELETE and TRUNCATE commands are :

* DELETE is a DML command, whereas TRUNCATE is a DDL command

* DELETE removes records and records each deletion in the transaction log, whereas TRUNCATE deallocates pages and records each deallocation in the transaction log

* TRUNCATE is generally considered quicker as it makes less use of the transaction log