Difference Between Delete & Truncate Statement? Which Statement Can B

1.	Difference Between Delete & Truncate Statement? Which Statement Can Be Rollbacked?
Answer» With DELETE we can provide CONDITIONAL WHERE clause to remove/delete specific rows, which is not possible with TRUNCATE. TRUNCATE is faster than DELETE as Delete keeps LOG of each row it deletes in transaction logs, but truncate keeps log of only de-allocated PAGES in transaction logs. Both statements can be rolled backed if provided in a transaction (BEGIN TRANS). If not then none of them can be rollbacked. DELETE is DML just like INSERT, UPDATE, but TRANCATE is DDL, just like CREATE, ALTER, DROP.

Difference Between Delete & Truncate Statement? Which Statement Can Be Rollbacked?

Answer»

With DELETE we can provide CONDITIONAL WHERE clause to remove/delete specific rows, which is not possible with TRUNCATE.
TRUNCATE is faster than DELETE as Delete keeps LOG of each row it deletes in transaction logs, but truncate keeps log of only de-allocated PAGES in transaction logs.
Both statements can be rolled backed if provided in a transaction (BEGIN TRANS). If not then none of them can be rollbacked.
DELETE is DML just like INSERT, UPDATE, but TRANCATE is DDL, just like CREATE, ALTER, DROP.