+ 5

What is the difference between DELETE and TRUNCATE in SQL?

What is the difference between DELETE and TRUNCATE in SQL?

26th Mar 2018, 10:59 AM
Swamy
Swamy - avatar
4 Respostas
+ 8
if you drink a can of coke, you delete. if you throw away the can, you truncate.
26th Mar 2018, 11:41 AM
Oma Falk
Oma Falk - avatar
+ 5
@Lunar Coffee I just imagined that magic moment. Well.... yes.... 🤮🤮🤮
26th Mar 2018, 2:19 PM
Oma Falk
Oma Falk - avatar
+ 4
Also, you can magically make the coke go back in the can (you can undo a DELETE), but you can't with TRUNCATE.
26th Mar 2018, 12:19 PM
LunarCoffee
LunarCoffee - avatar