Tuesday, March 19, 2013

Difference Between DROP, DELETE & TRUNCATE

          Drop            Delete           Truncate
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
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
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

No comments:

Post a Comment