Still have a problem with naming "foreign key" constraints on innodb tables.
Can't retrieve any of the name that was given to the constraints.
"Internally generated" IDs are always given to the foreign keys... no way to
apply a "drop foreign key 0_xxxx" on a replicated server or gererate
automatic update scripts.
This is from mySql documentation :
ALTER TABLE yourtablename
ADD [CONSTRAINT [symbol]] FOREIGN KEY (...) REFERENCES anothertablename(...)
What the "symbol" value is use for ? if it is not handled : is this a bug ?
Is there any planned release of InnoDB that could handle the constraint
"foreign key" names ?
thanks in advance
Tel : 02 99 55 07 55
Fax : 02 99 55 08 64
E-mail : etudes@stripped
site vitrine : www.cedricom.com