DROP SCHEMA

What this does

Drops the schema itself; fails if it still contains objects unless CASCADE is added.

Read more

• /blog/postgres-lock-mode-cheat-sheet
• /blog/ddl-lock-cheat-sheet

More in Destructive Operations

• DROP TABLE CRITICAL
• ALTER TABLE ... DROP COLUMN HIGH
• ALTER TABLE ... DROP CONSTRAINT MEDIUM
• DROP SCHEMA ... CASCADE CRITICAL
• TRUNCATE CRITICAL
• TRUNCATE ... CASCADE CRITICAL