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.

 Collapse All    Expand All
Custom Search

Oracle Information and Resources