[Solved] - Magento - Cannot delete or update a parent row: a foreign key constraint fails

If you get the following error while trying to drop your Magento tables all you need to do to delete the remaining tables is, first try and drop a few tables from top or bottom and then try deleting the remaining tables all at once.

This should work.