(1)創(chuàng)建表
create table userinfos (
?? user_id int8,
?? username varchar(40),
?? password varchar(60)
)

(2)添加逐漸約束

?alter table userinfs add primary key (user_id);

(3)創(chuàng)建表的時(shí)候直接指定主鍵
create table userinfos (
?? user_id int8 primary key,
?? username varchar(40),
?? password varchar(60)
)

(4) 創(chuàng)建表orders

create table orders (
? order_id int8 primary key,
? user_id int8,
? order_date date
)

(5)創(chuàng)建外建

alter table orders add foreign key (user_id) reference userinfos(user_id);

(6)創(chuàng)建表的時(shí)候指定外建

create table orders (
? order_id int8 primary key,
? user_id int8 references userinfos(user_id),
? order_date date
)

(7)刪除約束
查看約束的名字 ，比如userinfos_pkey
alter table userinfs drop constraint "userinfos_pkey"
?









|----------------------------------------------------------------------------------------|
                           版權(quán)聲明  版權(quán)所有 @zhyiwww
            引用請(qǐng)注明來源 http://m.tkk7.com/zhyiwww   
|----------------------------------------------------------------------------------------|