Deleting a table
-
DROP TABLE: The required DROP TABLE keywords begin the DDL statement which deletes a table and all associated database
objects.
- tablename: The tablename must identify an existing table.
The corresponding SQL is
DROP TABLE [schema.]table [CASCADE CONSTRAINTS]
- schema : is the schema containing the table. If you omit schema, Oracle assumes the table is in your own schema.
- table : is the name of the table to be dropped.
-
CASCADE CONSTRAINTS : drops all referential integrity constraints that refer to primary and unique keys in the dropped table.
If you omit this option and the referential integrity constraints exist, Oracle returns an error and does not drop the table.