This is weird and I haven't ever encountered this.
I'm simply dropping a whole database.
$ mysql -u $RDS_USER -p$RDS_PASS -h $RDS_HOST -e "DROP DATABASE dev_test"
And yet it fails with this...
ERROR 1217 (23000) at line 1: Cannot delete or update a parent row: a foreign key constraint fails
I then go to the database itself and I see that most of the tables have been dropped except for two.
Why does this happen?
I'm using MySQL 5.6.