how does that solution work if the table that is dropped has foreign key constraints?

That's why I said:

> disabling foreign key checks on large operations

And you have to know that, according to your business logic, what you're doing is safe.