Differences between Delete and Truncate

Differences between Delete and Truncate


Delete
1. Structure will not drop, data will drop.
2. Can Rollback
3. Can use WHERE clause
4. Row by Row data Delete
5. Delete is a DML Statement


Truncate
1. Structure will not drop data will drop.
2. Can’t Rollback
3. Can’t use WHERE clause
4. Only all data will drop, truncate operation drop and recreate the table.
5. Truncate is a DDL Statement

Drop
1. Whole structure and data will drop.
2. Can’t Rollback
3. Can’t use where clause
4. All data and structure drop simultaneously.
5. Drop is a DDL Statement