你最崇拜谁,彭城招聘网,红毛qq秀
当你更新或删除主键表时,那么外键表也会跟随一起更新或删除,需要在建表时设置级联属性
create table countries(countryid int primary key)
insert into countries (countryid) values (1)
insert into countries (countryid) values (2)
insert into countries (countryid) values (3)
create table cities( cityid int primary key ,countryid int references countries on delete cascade);
insert into cities values(1,1)
insert into cities values(2,1)
insert into cities values(3,2)
create table buyers(customerid int primary key ,cityid int references cities on delete cascade);
insert into buyers values(1,1),
insert into buyers values(2,1)
insert into buyers values(3,2)
此外还有级联更新
on update cascade
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
数据库SQL---数据库、基本表、视图、索引的定义、修改、删除
在 Azure CentOS VM 中配置 SQL Server 2019 AG - (上)
在 Azure CentOS VM 中配置 SQL Server 2019 AG - (下)
网友评论