SQL Guide : Using SQL for database administration : Managing database objects : Deleting a schema
  
Deleting a schema
DROP SCHEMA schema_name
The following example deletes the schema named FINANCE.
DROP SCHEMA FINANCE;
See also
Managing database objects