SQL Sage Road Note--sql Truncate,delete,drop

TRUNCATE table is functionally the same as a DELETE statement without a WHERE clause: Both delete all rows in the table. However, TRUNCATE TABLE is faster than DELETE and uses less system and transaction log resources. The DELETE statement deletes one row at a time and records an entry in the transaction log for each row that is deleted.
TRUNCATE table deletes data by releasing the data page used to store the table data, and records the release of the page only in the transaction log.
Truncate,delete,drop to compare:
TRUNCATE TABLE: Delete content, free space, but do not delete definition.
Delete TABLE: Deletes the definition without deleting the content and does not free up space.
Drop TABLE: Removes content and definitions and frees up space.

SQL Sage Road Note--sql Truncate,delete,drop