From: Martijn Tonies
Date: October 19 2004 9:53am
Subject: Re: Innodb foreign keys names
List-Archive: http://lists.mysql.com/mysql/174441
Message-Id: <01ad01c4b5c1$7c1e69a0$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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 : 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=m.tonies@stripped