René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -

drop table [Oracle SQL]

drop table table_name;
drop table table_name cascade constraints;
drop table table_name purge;
The drop table command moves a table into the recycle bin unless purge was also specified.


Normally, a table is moved into the recycle bin (as of Oracle 10g), if it is dropped. However, if the purge modifier is specified as well, the table is unrecoverably (entirely) dropped from the database.

cascade constraints

Deletes all foreign keys that reference the table to be dropped, then drops the table.


Thanks to Steve Parker and Thorir Olafsson who notified me of a typo on this page.