--創(chuàng)建時添加主鍵約束
create table userinfo_p (
id number(6,0) primary key,
userpwd varchar2(20)
)
--創(chuàng)建時添加聯(lián)合主鍵約束
create table userinfo_p1(
id number(6,0),
username varchar2(20),
userpwd varchar2(20),
constraint pk_id_username primary key (id,username)
)