Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What’s the difference between DELETE TABLE and TRUNCATE TABLE commands in SQL?

April 26, 2017commands delete difference sql Table truncate

0

Posted

What’s the difference between DELETE TABLE and TRUNCATE TABLE commands in SQL?

1 Answer

0

Posted

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.