Oracle DROP TABLE statement is used to remove or delete a table from the Oracle database.
DROP [schema_name].TABLE table_name [ CASCADE CONSTRAINTS ] [ PURGE ];
schema_name: It specifies the name of the schema that owns the table.
table_name: It specifies the name of the table which you want to remove from the Oracle database.
CASCADE CONSTRAINTS: It is optional. If specified, it will drop all referential integrity constraints as well.
PURGE: It is also optional. If specified, the table and its dependent objects are placed in the recycle bin and can?t be recovered.
DROP TABLE customers;
DROP TABLE customers PURGE
This statement will drop the table called customers and issue a PURGE so that the space associated with the customers table is released and the customers table is not placed in recycle bin. So, it is not possible to recover that table if required.