Difference between Delete and Truncate:
| Delete | Truncate | |
| 1 | Delete activates Triggers | Truncate does not activates Triggers |
| 2 | It’s a DML Command | It’s a DDL Command |
| 3 | Can be Roll-backed | Cannot be Roll-backed |
| 4 | It is slower as compared to truncate | Its is Faster |
| 5 | Can use Where clause in the delete command | Cannot use Where clause in the truncate command |
| 6 | Each Table Row is locked while deleting | Whole Table is Locked while performing truncate operation |
| 7 | Maintains the identity of the column | Does not maintain the identity of the column |
 |
| Delete Command Maintains Identity of the Column |
