Pk:主键,不能重复,非空
Fk:外键,引用另一个表的Pk,可以重复。
联合主键:引用2个表的PK,作为本表的主键。
应用举例:建三张表,增加约束
一建表:create table student(
s_id varchar2(10),
name varchar2(10)
)
tablespace myspace
create table couse (
c_id varchar2(10),
name varchar2(10)
)
tablespace myspace
create table sc(
s_id varchar2(10),
c_id varchar2(10),
s_name varchar2(10),
c_name varchar2(10)
)
tablespace myspace
二增加主键约束,联合主键约束:
alter table STUDENT add primary key (s_id)
alter table couse add constraint c_pk primary key (c_id)
alter table sc add constraint sc_id primary key(s_id,c_id)
三给表sc添加外键,并且引用student和couse表s_id,c_id,并通过on delete cascade指定引用行为是级联删除
alter table sc add constraint sc_fk foreign key(s_id) references student(s_id)on delete cascade;
alter table sc add constraint sc_f foreign key(c_id) references couse(c_id)on delete cascade;
四增加非空约束
三给表增加非空约束
alter table student modify s_id not null;
alter table couse modify c_id not null;