Dropping a schema

To drop a schema:

Procedure

  1. In the navigation tree, click Database and select a catalog.
  2. In the left pane for Schemas folder within the catalog, select a schema and right-click and select Drop Schema.

    Confirm Drop Schema dialog appears.

  3. Select Restrict or Cascade option.

    • If you select Restrict and the specified schema is not empty, an error is returned.

    • Select Cascade to drop the schema in addition to the objects in the specified schema.

  4. Click Yes to drop the schema.