Saturday 6 June 2015

Difference between TRUNCATE and DELETE

  • Both result in deleting of the rows in the table
  • TRUNCATE call cannot be rolled back  and all memory space for that table is released back to the server while DELETE call can be rolled back
  • TRUNCATE call is DDL command while DELETE call is DML command
  • TRUNCATE call is faster than DELETE call

No comments:

Post a Comment