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.

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.

cascade constraints

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

Thanks

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

Dropping a View: Example

The following statement drops the emp_view view, which was created in "Creating a View: Example":

DROP VIEW emp_view; 

---

span>