It sucks, but sometimes ya gotta.
You can’t DROP multiple tables, a parent table or a child table until you disable foreign key checks four your current database. Or for that matter, TRUNC the table, either.
To disable/enable foreign key checks, use the following syntax. (Don’t ever disable @@GLOBAL, unless you’re really irritated and have lost your mind)
SET @@SESSION.FOREIGN_KEY_CHECKS = 'OFF'; SET @@SESSION.FOREIGN_KEY_CHECKS = 'ON';