Both the commands are used to remove data from the database.
The difference between the two include:
- TRUNCATE is a DDL operation while DELETE is a DML operation.
- TRUNCATE drops the structure of a database and hence cannot be rolled back while the DELETE command can be rolled back.
- The TRUNCATE command will free the object storage space while the DELETE command does not.