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 >
