- 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
By Gurpreet Singh, Department of Computer Science & Engineering, Amritsar College of Engineering & Technology
Saturday, 6 June 2015
Difference between TRUNCATE and DELETE
Labels:
SQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment