Why Can't I Drop an Index for a Column with a Foreign Constraint?
(Doc ID 1023180.1)
Last updated on OCTOBER 17, 2017
Applies to:MySQL Server - Version: 4.0
MySQL Server - Version: 4.0 to 5.5 [Release: 4.0 to 5.5]
ALTER TABLE table1 DROP INDEX index1;
ERROR 1025 (HY000): Error on rename of ... to ... (errno: 150)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!