Why Truncate is DDL?

[SQLTweety]

Glad I could help


Keep inventing.

Regards.

[swaticsabale]

TRUNCATE TABLE handles table as an entity to clear all data from the specified table. It does not create log while deleting data from the table so it can not be rolled back. As it handles table it is DDL i.e Data Definition Language command.

Where as DELETE command deletes specified rows with WHERE condition so it is DML.
DELETE command creates log entry after deleting rows so can be rolled back.