What is the difference between Truncate and Delete?

 Posted by Poster on 4/24/2008 | Category: Sql Server Interview questions | Views: 12231

Delete statement removes rows of a table one by one & delete triggers on that table fires. But Truncate removes all rows by deallocating the data pages assigned to the table & only these deallocation are recorded in the transaction log.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Kundan64 on: 12/19/2012 | Points: 10
We can use WHERE clause with Delete statement but not with Truncate statement.

Login to post response