Delete Truncate
Type DML DDL
Rollback Possoble Not possible
Space Reclamation Does not recover space Recover space
Indexes NA Renders unusable indexes usable again
Object Type Delete can be applied to tables and tables inside a cluster. Truncate applies only to tables or the entire cluster.
Identity Columns NA Resets the sequence for IDENTITY column types
Locking At row level At table and page level
Where Clause Can use where clause Can not use in where clause
Data Removal Deletes specified data if where condition exists Removes all the data
Speed Slower than truncate Faster in performance wise
Keeps Logs Yes No
Activate Trigger Activates a trigger because the operation is logged individually Cannot activate a trigger because the operation does not log individual row deletions.