Oracle - SQL Table Basics - Drop Table

Drop table

Of course, be careful using this function.

DROP TABLE PERSON.PERSON CASCADE CONSTRAINTS 
/

Note: You cannot drop a table that is referenced by a foreign key constraint. This is a very good thing. So, in the above example the only way to drop the person table would be to also drop the address table and the phone table.