+2 votes
in Databases by (71.8k 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

+1 vote
by (71.8k points)
selected by
 
Best answer

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

Related questions

+3 votes
1 answer
+2 votes
1 answer
+2 votes
1 answer
+3 votes
1 answer

...