How is it different from DELETE statement?


Please explain why do you think this question should be reported?

Report Cancel

Difference between DELETE and TRUNCATE statement:
DELETE statement is utilized to remove at least one columns from a table and also the entire table. Also the TRUNCATE TABLE statement is utilized to delete the entire table for permanently.
TRUNCATE TABLE statement is same as DELETE statement without a WHERE condition.
DELETE statement removes rows one at a time and records an entry in the exchange log for each deleted row.
TRUNCATE TABLE removes the information by deallocating the information pages used to store the table information and record just the page deallocations in the exchange log. Hence it is quicker than delete statement.

Please follow and like us:

About the Author