top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

What is the difference between DELETE TABLE and TRUNCATE TABLE commands?

+1 vote
131 views
What is the difference between DELETE TABLE and TRUNCATE TABLE commands?
posted Mar 26, 2014 by Vishvachi Tiwari

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

Following are difference between them:-
• DELETE TABLE syntax logs the deletes thus make the delete operation slow.
TRUNCATE table does not log any information but it logs information about
deallocation of data page of the table so TRUNCATE table is faster as compared to
delete table.
• DELETE table can have criteria while TRUNCATE cannot.
• TRUNCATE table does not invoke trigger.

answer Mar 26, 2014 by Atul Mishra
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...