Procedure documentationDeleting Schemas Locate this document in the navigation structure

Prerequisites

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

  • The database is in the ONLINE operational state.

Procedure

In the context menu of the schema, choose Delete.

Cascade Options for Deleting Schemas

Option

Description

Cascade

The schema and all database objects belonging to the schema are 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)