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

Reply via email to