Q. What is the Difference between Delete and Truncate Command
Delete Truncate
1) Delete Record do not 1) The record will save until they be remove permanently
are committed and they by the truncate command
can be Roll backed.
2) Delete Command effects in 2) Truncate command do
Triggers. not effect Triggers
3) It Process is slow 3) Process fast as
compare to Delete
Delete Truncate
1) Delete Record do not 1) The record will save until they be remove permanently
are committed and they by the truncate command
can be Roll backed.
2) Delete Command effects in 2) Truncate command do
Triggers. not effect Triggers
3) It Process is slow 3) Process fast as
compare to Delete
No comments:
Post a Comment