> you have to use a fairly recent 4.0 or 4.1 version of MySQL.
Does a newer version allow you to change/set the names yourself?
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
> Hi everybody,
> Still have a problem with naming "foreign key" constraints on innodb
> 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
> 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
> 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
> Richard FURIC
> Tel : 02 99 55 07 55
> Fax : 02 99 55 08 64
> E-mail : etudes@stripped
> site vitrine : www.cedricom.com
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1