How to drop multiple tables having foreign keys in PostgreSQL?

Question

I know syntax for deleting multiple tables is:

DROP TABLE foo, bar, baz;

But in my case 3 tables having foreign keys in between them and with other tables which are not to be deleted.

• Table1: Foreign keys From Table2, Table3, 3 more tables in database.
• Table2: Forign keys From Table3, 2 more tables in database.
• Table3: Forign keys From 3 more tables in database.

So how can I drop these 3 tables? They are having data in tables. Will above syntax work ignoring foreign keys? There should not be any data inconsistency in other tables in database.

Answer 1

You can tell Postgres to automatically drop all foreign keys referencing those tables by using the cascade keyword:

DROP TABLE foo, bar, baz CASCADE;