Martin Jakob
What's the difference between DELETE TABLE and TRUNCATE TABLE commands
By Martin Jakob in ASP.NET on Nov 29 2006
  • Priyanka
    Nov, 2007 8

    Last line is INCORRECT. Truncate Table CAN'T be rolled back.

    • 0
  • canuja
    Nov, 2006 29

    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, TRUNCATE TABLE can be rolled back.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS