PostgreSQL – Dropping a Schema

Below is the syntax to drop a schema in postgres database.

DROP SCHEMA schemaname; 

Above statement will fail if the schema has any database objects in it. Use cascade option to delete the schema along with the database objects inside the schema as well as any dependent objects.

DROP SCHEMA schemaname CASCADE; 

See also  PostgreSQL - IS NOT NULL