create table cat_tb ( cat_id int primary key, cat_name varchar(20) ) go insert into cat_tb values(100,'数码电子') insert into cat_tb values(200,'化妆品') insert into cat_tb values(300,'家具') gocreate table sub_tb ( sub_id int primary key, sub_name varchar(20), cat_id int foreign key(cat_id) references cat_tb(cat_id) ON DELETE CASCADE ON UPDATE CASCADE ) go DROP TABLE sub_tb,cat_tb
(
cat_id int primary key,
cat_name varchar(20)
)
go
insert into cat_tb values(100,'数码电子')
insert into cat_tb values(200,'化妆品')
insert into cat_tb values(300,'家具')
gocreate table sub_tb
(
sub_id int primary key,
sub_name varchar(20),
cat_id int foreign key(cat_id) references cat_tb(cat_id) ON DELETE CASCADE ON UPDATE CASCADE
)
go
DROP TABLE sub_tb,cat_tb