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 also write your article here or mail your article to email@example.com . See your article appearing on the dEexams.com main page and help others to learn.
Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.