What is the difference between DELETE and TRUNCATE commands?

Started by Derek, April 23, 2016, 01:22:27 PM

Previous topic - Next topic

Kevin

Hi, I have a big question about this topic, what is the difference between delete and truncate commands? Thank you for helping me please.

Kyron

The DELETE command is used to remove rows from a table.But truncate will delete the contenets only not the strucure