Syntax
The DROP SCHEMA statement has the following format:
DROP SCHEMA schema_name RESTRICT | CASCADE
RESTRICT
Does not drop the schema if one or more objects are associated with it.
CASCADE
Deletes all objects (tables, views, grants) that are associated with the schema.