You need to delete the key using its own private name:
LIST CONSTRAINTS FOR ProdLocation
You will see a list of constraints named #nnn
ALTER TABLE ProdLocation DROP CONSTRAINT #nnn
Bernard Lis <[EMAIL PROTECTED]> wrote:
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
Albert Berry
Management Consultant
RR2 - 1252 Ponderosa Drive
Sparwood BC, V0B 2G2
Canada
(250) 425-5806
(250) 425-7259
(708) 575-3952 (fax)
[EMAIL PROTECTED]
