[whiter]

According to the MySQL documentation, the ALTER TABLE DROP FOREIGN KEY internally_generated_foreign_key_id command will work from version 4.0.13.

I have 4.0.12 :-(

Is there a way to drop the constraint in 4.0.12.

*** ALSO ***
Again, according to the documentation:
"Starting from version 3.23.50 InnoDB returns the foreign key definitions of a table when you call

SHOW CREATE TABLE yourtablename"

Well ... It doesn't do so with my 4.0.12 vesion!

Any ideas on how I can determine the foreign key being used by a constraint?

[omiossec]

With innodb table on mysql < 4.013 you simply alter the table (cange an index for example) and the foreign key will be drop

[omiossec]

With innodb table on mysql < 4.013 you simply alter the table (cange an index for example) and the foreign key will be drop