- 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 Er Gurpreet Singh,
Senior Software Engineer,
Sopra Steria India
Tuesday, 22 July 2014
Difference between TRUNCATE and DELETE
Labels:
SQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment