Sql Foreign Key Constraint Error 1025 (152)

I keep getting an error every time i try to drop a table called 'countires' and a field called 'countries'. #1025 - Error on rename of '.\mutli_page_form\survey' to '.\mutli_page_f

Solution 1:

The database has been told to ensure data integrity. This is what you're seeing. There is survey data that references a country. If you delete the country table then the survey data won't have valid countries associated with it. You'll have to remove the surveys first before you can remove the countries.

Solution 2:

You must set index both for id ()'s in 2 tables -> after try again