Difference between TRUNCATE & DELETE commands in SQL- Interview questions
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:
Post a Comment