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;
Admin on Apr 20, 2019 at 12:02 am
If you like dEexams.com and would like to contribute, you can 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.