+2 votes
in Databases by (14.2k points)
retagged by
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?

1 Answer

0 votes
by (14.2k points)
edited by

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