DELETE

• The DELETE command is used to delete a row in a table.
• You can roll back data after using the delete statement.
• It is a DML (Data Manipulation Language) command.
• It is slower than the TRUNCATE statements.

TRUNCATE

• The TRUNCATE is used to delete all the rows from a table.
• You cannot roll back data.
• It is a DDL (Data Definition Language) command.
• It is faster.