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

Read Online SQL Job Interview Questions And Answers