CODEWITHSUNDEEP
mysqlsqlmysql-error-1025
Xavier
Xavier

Reputation: 8362

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_form\#sql2-820-1fb' (errno: 152)

It says there is a FK dependency on the table "survey" i have tried multiple times to delete it to no success.

#1217 - Cannot delete or update a parent row: a foreign key constraint fails

I now get this error once trying to delete the table of Countries

Upvotes: 4

Views: 7934

Answers (2)

Trần Tuấn Sơn
Trần Tuấn Sơn

Reputation: 21

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

Upvotes: 1

Jay
Jay

Reputation: 14441

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.

Upvotes: 4

Related Questions