What is different between TRUNCATE and DELETE?

Q

What is different between TRUNCATE and DELETE?

✍: Guest

A

The Delete command will log the data changes in the log file where as the truncate will simply remove the data without it. Hence Data removed by Delete command can be rolled back but not the data removed by TRUNCATE. Truncate is a DDL statement whereas DELETE is a DML statement.

2011-08-30, 3021👍, 0💬