DROP SCHEMA ... CASCADE

What this does

Walks every dependency and drops all of it: tables, views, functions, everything inside the schema, irreversibly. CASCADE on a schema is one of the widest-blast-radius statements Postgres has.

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 CRITICAL
• TRUNCATE CRITICAL
• TRUNCATE ... CASCADE CRITICAL