What is the difference between DELETE and TRUNCATE in SQL?

Question

What is the difference between DELETE and TRUNCATE in SQL?

Answer 1

if you drink a can of coke, you delete.

if you throw away the can, you truncate.

Answer 2

http://beginner-sql-tutorial.com/sql-delete-statement.htm

https://www.codeproject.com/questions/370759/difference-between-delete-and-truncate

Hth, cmiiw

Answer 3

@Lunar Coffee
I just imagined that magic moment.
Well.... yes.... 🤮🤮🤮

Answer 4

Also, you can magically make the coke go back in the can (you can undo a DELETE), but you can't with TRUNCATE.