You are logged on to the database as the user who is owner of the schema.
The database is in the ONLINE operational state.
In the context menu of the schema, choose Delete.
Select the 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. |
SQL Reference Manual, DROP SCHEMA Statement (drop_schema_statement)