What's the difference between DELETE TABLE and
TRUNCATE TABLE commands?

 Posted by Prabhukiran345 on 12/30/2013 | Category: Sql Server Interview questions | Views: 3135 | Points: 40
Answer:

1. DELETE TABLE syntax logs the deletes thus making the delete operation slow.TRUNCATE table does not log any information but it logs information about deallocation of data page of the table.

2.DELETE table can be rolled back while TRUNCATE can not be.

3.DELETE table can have criteria while TRUNCATE can not.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response