Heikki, > 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? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com > Hi everybody, > > 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 > regards > > > -- > Richard FURIC > CEDRICOM > Tel : 02 99 55 07 55 > Fax : 02 99 55 08 64 > E-mail : [EMAIL PROTECTED] > site vitrine : www.cedricom.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]