DROP TABLE statement - To Delete Table

Oracle DROP TABLE statement is used to remove or delete a table from the Oracle database.

Syntax:

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.

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 Example:

DROP TABLE students;

This will drop the table named customers.

DROP TABLE Example with PURGE

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.

Thank you for reading.

If you have any doubt , Free Free to comment down Below.