Delete table in Oracle drop delete truncate

At the same point, using drop Delete truncate will delete the contents of the table

DROP table Name

Delete from table name (followed by the where statement, and all data in the table is also deleted)

TRUNCATE TABLE name

Difference

First, delete belongs to DML, which does not take effect when not commit.

The truncate and the drop are directly in effect and cannot be rolled back.

Truncate and delete Do not delete the structure of the table, except for the contents of the table

The drop statement will delete the structure of the table, dependent constraints (constrain), triggers (trigger), index; Stored procedures/functions that depend on the table are preserved, but become invalid states.

Truncate will free up space, and drop and delete will not.

Speed: Drop>truncate>dalete

In summary, you can get a problem that using drop and truncate relative to delete is dangerous and cannot be rolled back when using drop and truncate. Delete is relatively secure, can be rolled back, and commits are committed later, and the table structure is not deleted, and the space occupied by the table is not freed.

Delete table in Oracle drop delete truncate