Oracle - SQL Table Basics - 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.