SQL Interview Question:

What is the difference between TRUNCATE and DELETE commands?

Submitted by: Administrator

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 and not with TRUNCATE.
Submitted by: Administrator