Show TOC

Deleting TablesLocate this document in the navigation structure

Prerequisites

  • 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.

Context

You delete a table in the explorer tree.

Note

To delete tables, you can also use SQL statements.

More information:

Procedure

  1. Select the table in the Explorer.
  2. 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.

Next Steps

Creating Tables