top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+1 vote
423 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 LinkedIn 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
...