DROP SCHEMA deletes a schema in a database.
Only a schema owner or a system administrator can run the DROP SCHEMA command.
DROP SCHEMA [ IF EXISTS ] schema_name [, ...] [ CASCADE | RESTRICT ];
Sends a notice instead of an error if the specified schema does not exist.
Specifies the name of a schema.
Value range: An existing schema name.
Do not delete the schemas with the beginning of pg_temp or pg_toast_temp. They are internal system schemas, and deleting them may cause unexpected errors.
A user cannot delete the schema in use. To delete the schema in use, switch to another schema.
See Examples in CREATE SCHEMA.