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