create table job
(
jid int primary key,
jname varchar(10),
)
go
create table dept
(
deptid int primary key,
dname varchar(10),
)
go
create table emp
(
eid int primary key,
ename varchar(10),
deptid int references dept(deptid) on delete cascade on update no action,--级联删除,不级联更新
jid int references job(jid) on delete cascade on update cascade ,--级联删除,级联更新
)
级连删除,级连更新
最新推荐文章于 2023-02-10 10:40:12 发布