|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
drop table [Oracle SQL]
drop table table_name; drop table table_name cascade constraints; drop table table_name purge;
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.
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.