Oracle / PLSQL:DROP TABLE Statement . dEexams.com

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

Syntax

DROP TABLE [schema_name].table_name
[ CASCADE CONSTRAINTS ]
[ PURGE ];

schema_name :

The name of the schema that owns the table.

table_name :

The name of the table to remove from the Oracle database.

CASCADE CONSTRAINTS :

Optional. If specified, all referential integrity constraints will be dropped as well.

PURGE :

Optional. If specified, the table and its dependent objects will be purged from the recycle bin and you will not be able to recover the table. If not specified, the table and its dependent objects are placed in the recycle bin and can be recovered later, if needed.

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.

Example :

DROP TABLE table_name PURGE;

Uk01 on Sep 09, 2020 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 admin@deexams.com . See your article appearing on the dEexams.com main page and help others to learn.