Re: Innodb foreign keys names

Thanks Heikki for your response : it works perfectly with the brand new version (4.1.6), I'm gonna drop all my old foreign keys now and rename them with an appropriate name... bye -- Richard FURIC CEDRICOM Tel : 02 99 55 07 55 Fax : 02 99 55 08 64 E-mail : [EMAIL PROTECTED] site vitrine : www.c

Innodb foreign keys names

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_" on a replicated server or ger

Re: Naming constraints

So how is it possible to drop a foreign key in a master / slave replication ? the autogenerated-naming constraint should be different ? How automatic database structure update can be executed (from a script generetor like PowerDesigner) ? thanks... ""Martijn Tonies"" <[EMAIL PROTECTED]> a écrit

Naming constraints

Hi, I have problem in naming foreign key constraints : Engine : mySql 4.1.1 and/or 5.0.0a System : Windows 2000 sp4 and / or win NT 4 sp6a Here is a script example of what I need to do : /* Script 1 */ CREATE TABLE tblphone ( nameid INT PRIMARY KEY AUTO_INCREMENT, fnameVARCHAR(30),