When I try to drop an index in MySQL, I get an error. This is because there
exists a foreign key on the indexed column.
I don't want to drop the Foreign Key. A workaround for this is turning off
the Foreign Key Checks using
But this doesn't seem to work in many of the MySQL versions.
I'm using MySQL 4.0.17. Does anyone know how to get rid of this error?
Senior Software Engineer
SunGard Offshore Services
Ph. +91 20 2560 6082
|• Turn off foreign key checks||Kalyani Kale||9 Feb|