Show TOC

Deleting SchemasLocate 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.

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