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:
Post a Comment