Dinesh Beniwal
Can you tell me the difference between DELETE & TRUNCATE commands?
Posted by Dinesh Beniwal in SQL Server on Jul 15, 2006
  • 0
  • 2
  • 8024
Do you know the answer for this question? Post it below.
Posted by raemz on Aug 25, 2006
  • 0

Hi Praveen,

TRUNCATE is also rollback the data.But difference is TRUNCATE can't mantian the log.


Posted by pravs on Jul 24, 2006
  • 0

TRUNCATE is a DDL command and cannot be rolled back. All of the memory space is released back to the server. 
DELETE is a DML command and can be rolled back. 
Both commands accomplish identical tasks (removing all data from a table), but TRUNCATE is much faster.

More info at :