You delete a table in the explorer tree.
Note
To delete tables, you can also use SQL statements.
More information:
SQL Reference Manual, DROP TABLE Statement (drop_table_statement)
You are logged on to the database as a database user.
You are the owner of the table or have the DROPIN privilege for the schema to which the table belongs.
More information: SQL Reference Manual, Privilege Specification for a Schema (schema_priv_spec)
The database is in the ONLINE operational state.
Select the table in the Explorer.
Choose Delete in the context menu of the table.
Option |
Description |
---|---|
Cascade |
All of the metadata and rows in the table are deleted, along with the view tables, indexes, privileges, synonyms, and referential CONSTRAINT definitions derived from the table. |
Restrict |
The system can only delete the table if no dependencies exist. Example: The table cannot be deleted if a view table is based on it. |
Delete Catalog Object |
Deletes both the table definition (in the database catalog) and the table contents. |
Delete All Rows |
Only deletes the table content, but not the table definition. |
The system deletes all data records, the table definition, and all view tables, privileges, synonyms, and referential constraint definitions derived from the table.