What is the difference between DELETE TABLE and TRUNCATE TABLE commands?

Posted by

To view Verified answers click on the button below.

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 de-allocation of the data pages
of the table, which makes it faster. Of course, TRUNCATE TABLE can be rolled back.