oracle创建联合主键

create table table_name

(

first_name varchar2(12),

second_name varchar2(10),

idcard varchar(36),

home_name varchar(66),

constraint pk_table_name primary key(first_name,second_name,idcard) -- 联合主键

)

2.创建表之后追加联合主键

alter table table_name add constraint pk_table_name primary key (first_name,second_name)

CREATE TABLE TAB (

ID1 NUMBER(10) ,

ID2 NUMBER(4),

CREDIT NUMBER(2),

CONSTRAINT PK_TAB PRIMARY KEY (ID1,ID2) -- 主键

)

或者建表之后追加

alter table tab add constraint pk_tab2 primary key (id1,id2)