What is the difference between DELETE and TRUNCATE statement?
Ankur Jain
Truncate: Frees the space of table after executing. Delete: It will not frees the space of table.
A DELETE statement enables you to selectively remove data from a table, whereas The TRUNCATE statement unconditionally removes all rows from a table.