Thank you Alastair, There 2 constraints on the prodlocation table with id 33 and 50 so I tried: Alter Table prodlocation Drop constraint #50 and it worked. Bernie Lis ----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Sunday, September 05, 2004 2:42 AM Subject: [RBG7-L] - Re: duolicate Foreign key problem
> Bernie, does one of the constraints have a name or do both have different > names? > > If so, you could try: > > Alter Table prodlocation Drop CONSTRAINT [name] > > Regards, > Alastair. > > > ----- Original Message ----- > From: "Bernard Lis" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Sunday, September 05, 2004 2:28 AM > Subject: [RBG7-L] - duolicate Foreign key problem > > > > in Concomp database: > > alter table prodlocation add foreign key (model) references product > > > > now there are 2 keys, the same. > > > > How do I delete one? > > alter table prodlocation drop foreign key (model) > > results in table constraints can only be added or dropped > > > > Bernie Lis > > > >
