create table student
(
id int primary key identity(1,1),
name varchar(30),
)
create table exam
(
id int primary key identity(1,1),
typeid int constraint mypkid foreign key (typeid) references student(id)on delete cascade,
-- on update cascade
chinaese tinyint
)
--alter table exam drop constraint
不过我还是喜欢使用触发器!
(
id int primary key identity(1,1),
name varchar(30),
)
create table exam
(
id int primary key identity(1,1),
typeid int constraint mypkid foreign key (typeid) references student(id)on delete cascade,
-- on update cascade
chinaese tinyint
)
--alter table exam drop constraint
不过我还是喜欢使用触发器!