RelationalDBDesign
RedhatLinuxSys Seomining
prev prev
Course navigation
Deleting a table
Dropping a table
  1. DROP TABLE: The required DROP TABLE keywords begin the DDL statement which deletes a table and all associated database objects.
  2. tablename: The tablename must identify an existing table.
To remove a table and all its data from the database.
The corresponding SQL is
DROP TABLE [schema.]table 
[CASCADE CONSTRAINTS] 
  1. schema : is the schema containing the table. If you omit schema, Oracle assumes the table is in your own schema.
  2. table : is the name of the table to be dropped.
  3. 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.
Course navigation