Menu

Friday, 10 January 2014

Difference between Delete & Truncate



Differentiate between DELETE and TRUNCATE

Sr. No
Truncate
Delete
1
It cannot be rolled back
It can be
2
Truncate keeps the lock on table
Delete keeps the lock on each row.
3
Truncate resets the counter of the Identity column
It doesn’t do so
4
Trigger is not fired in Truncate
Trigger happens in table.


No comments: