DB2创建外键时选项如何快速掌握?
时间:2025-11-03 12:25:31 出处:IT科技阅读(143)
Create table student(student_id integer not null,创建student_name varchar(200), CONSTRAINT P_KEY_1 primary key (student_id)) in luzl_32k_tb index in luzl_32k_tb ; Create table class(class_id integer not null,class_name varchar(200), CONSTRAINT P_KEY_2 primary key (class_id)) in luzl_32k_tb index in luzl_32k_tb ; Create table student_class(student_class_id integer,student_id integer,class_id integer) in luzl_32k_tb index in luzl_32k_tb; alter table student_class add constraint if_class foreign key(class_id) references class(class_id) ON DELETE cascade ON UPDATE RESTRICT; alter table student_class add constraint if_student foreign key(student_id) references student(student_id) ON DELETE cascade ON UPDATE RESTRICT; Insert into student(student_id,student_name) values(1,luzl); Insert into class(class_id,class_name) values(1,db2); Insert into student_class(student_class_id,student_id,class_id) values(1,1,1); 1.2.3.4.5.6.7.8.9.10.11.12.
