|
What is the difference between TRUNCATE and DELETE commands ?
|
1. TRUNCATE is a DDL command whereas DELETE is a DML command.
2. DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back.
3. WHERE clause can be used with DELETE and not with TRUNCATE.
|
|
|
|
|
|
|
|