Delete and Truncate

Delete and Truncate

1) Delete is a DML Command while as Truncate is a DDL Command

2) Delete locks  table row while as Truncate locks entire table

3) We can use "where condition" with delete while as we can't user "where
condition" with Truncate

4) DML Trigger fired during the delete while as DML Trigger doesn't fire during the Truncate

5) We can rollback delete operation while as we can't rollback Truncate operation