Oracle Database Discussions

Hi ....

I'd like modify one primary key from 1 field to 2 field... but When I tried use alter table drop primary key.. I got message saying "this unique/primary key is referenced by some foreign keys"

What Should I do ? Drop first foreign key that use this primary ? or are there some way to modify primary key and the foreing are modify automaticly ?

Thank you..
Fernando.