Difference between TRUNCATE and DELETE commands

Difference between TRUNCATE and DELETE commands
TRUNCATE is a DDL command whereas DELETE is a DML command. Hence
DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back.
WHERE clause can be used with DELETE & not with TRUNCATE.

No comments: