Postgres - How to drop all tables without dropping database

Question

I have an schema with about 40 tables. I don't want to drop the database as it has several other schemas. How can I drop all tables of a particular schema?

Answer 1

Try 'drop schema XXXX cascade;' on postgres terminal where XXXX - schema name. It should drop all tables as well as schema.