oracle pl/sql

User_E03DK

i created composit primary on two column in a table . now i want to add one more column to same primary key

oracle database 12c

please let me now

cant we add another column to composit primary key with out dropping existing primary key?

Krishna Kanth G

Try this...(You must drop the old composite primary key before creating this)

ALTER TABLE <TABLE_NAME>

ADD CONSTRAINT <CONST_NAME> PRIMARY KEY (COL1_NAME, COL2_NAME,… , N);

Krishna Kanth G

User, please specify the database name(Oracle, MySQL, etc.,) that you are using.

User_E03DK

oracle database 12c

Krishna Kanth G

Try this...(You must drop the old composite primary key before creating this)

ALTER TABLE <TABLE_NAME>

ADD CONSTRAINT <CONST_NAME> PRIMARY KEY (COL1_NAME, COL2_NAME,… , N);

User_E03DK

can not we add with out drop old composit key?

EdStevens

can not we add with out drop old composit key?

No. So what's the problem with dropping the key immediately before re-creating it?