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

 Posted by Majith on 7/21/2008 | Category: Sql Server Interview questions | Views: 8001

DELETE TABLE is a logged operation, so the deletion of each row gets logged in the transaction log, which makes it slow. TRUNCATE TABLE also deletes all the rows in a table, but it won't log the deletion of each row, instead it logs the deallocation of the data pages of the table, which makes it faster. Of course.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Vivekjj on: 10/5/2012 | Points: 10
delete command is used to delete particular records or whole records from the table ,But, truncate command is used to delete whole records from the table

Login to post response