New course! Every coder should learn Generative AI!
Try a free lesson0
How to set two primary keys in one table in oracle?
set one primary key at table creation and another one is after creation of primary key.
3 Answers
0
You can add a unique constraint...even several...
+ 1
create table tablename (column1, column2 , primary key(column1,column2))
+ 1
One table can only have only one Primary Key, but can have more than 1 foreign key.
2 primary key is not necessary practically too.