I am generating a database schema via Java and want to drop only the tables I made changes to, in order to spare me from entering all the data again (or importing it from a manually updated dump).
But since nearly all the tables are connected via foreign keys in one way or another, MySQL-Workbench won't allow me to drop those single tables and gives me the following error:
ERROR 1217: Cannot delete or update a parent row: a foreign key constraint fails
SQL Statement:
drop table `mydb`.`mytable`
I am using MySQL 5.6 with InnoDB.