Answers for "Cannot drop index 'users_city_id_foreign': needed in a foreign key constraint"

0

Cannot drop index 'users_city_id_foreign': needed in a foreign key constraint

You have to drop the foreign key. Foreign keys in MySQL automatically create 
an index on the table

ALTER TABLE mytable DROP FOREIGN KEY mytable_ibfk_1 ;
Posted by: Guest on March-30-2022

Code answers related to "Cannot drop index 'users_city_id_foreign': needed in a foreign key constraint"

Browse Popular Code Answers by Language