The Oracle DROP TABLE statement is used to remove or delete a table from the Oracle database.
DROP TABLE [schema_name].table_name [ CASCADE CONSTRAINTS ] [ PURGE ];
Note : If there are referential integrity constraints on table_name and you do not specify the CASCADE CONSTRAINTS option, the DROP TABLE statement will return an error and Oracle will not drop the table.
DROP TABLE table_name PURGE;
If you like dEexams.com and would like to contribute, you can write your article here or mail your article to admin@deexams.com . See your article appearing on the dEexams.com main page and help others to learn.