--父表
create table clazz(
cno number(10),
cname char(10),
cdesc varchar2(100)
)
alter table clazz add constraints pk_clazz_cno primary key(cno)
alter table clazz add constraints ck_clazz_cno check(cno is not null)
truncate table clazz
insert into clazz values(1,'java','好好学习');
insert into clazz values(2,'java','好好学习')
update clazz set cno = 3,cname='python' where cdesc='好好学习'
alter table clazz add constraints ck_clazz_cno check(cno is not null)
alter table clazz drop constraints pk_clazz_cno
alter table clazz add constraints pk_clazz_cno primary key(cno)
drop table clazz
----------------------------
--子表
create table student(
sno number(10),
sname char(10),
sage number(10),
ssex char(10) check(ssex='男' or ssex ='女'),
sfav varchar2(100),
sbirth date,
sqq number(10),
constraints uk_student_sqq unique(sqq),
cid number(10)
)
alter table student add constraints fk_s
oracle中父表子表创建主外键约束
最新推荐文章于 2022-10-14 09:35:46 发布