Truncate removes all data, delete removes selected data.

• Truncate is faster than delete as it doesn't log individual row deletions.

• Truncate cannot be rolled back, delete can be.

• Truncate resets identity...read more

DELETE is a DML command and is used when specify the row we want remove or delete from the table

TRUNCATE is a DDL command is used to delete all the rows or tuples from the table

Truncate: It is a DDL command. It Cannot use in Where Condition. It is a Auto Commit.

Delete: It is a DML Command. It can use Where Condition Delete Specified Row or Column. It is Used In Commit.