Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to modify Primary constranints

sadasivamMay 31 2010 — edited Jun 1 2010
Hi,

My table table having composite primary with 2 columns,
now i need to add another one column in this group.
Number of child tables are refering this primary key.
is it only way to drop primary key and all foreign key and add newly?

is there possibilities to add column with out drop the reference constraints?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 29 2010
Added on May 31 2010
2 comments
609 views