Procedure documentationDeleting Schemas Locate this document in the navigation structure

Prerequisites

  • You are logged on to the database as the user who is owner of the schema.

  • The database is in the ONLINE operational state.

Procedure

  1. In the context menu of the schema, choose Delete.

  2. Select the CASCADE option:

    CASCADE Option

    Option

    Description

    CASCADE

    All database objects of the schema are also deleted.

    RESTRICT

    You can only delete the schema if it does not contain any database objects any more.

More Information

SQL Reference Manual, DROP SCHEMA Statement (drop_schema_statement)