Re: Naming constraints

2004-10-08 Thread Martijn Tonies
> So how is it possible to drop a foreign key in a master / slave replication > ? the autogenerated-naming constraint should be different ? I have no idea. > How automatic database structure update can be executed (from a script > generetor like PowerDesigner) ? With regards, Martijn Tonies

Re: Naming constraints

2004-10-08 Thread Richard - CEDRICOM
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

Re: Naming constraints

2004-10-08 Thread Martijn Tonies
Hello, > I have problem in naming foreign key constraints : --8<-- > Actually, the name for the just created constraint is an 'internally > generated id' (i.e :0_023), so the update script can't find the named > constraint 'fktblnumb' > > The "show create table tblnumbers" outputs : > > CREATE