通常说到外键,只会提到“外键的目的是确定资料的参考完整性(referential integrity)。”,但是外键具体包含哪些动作和含义呢?
1、设置外链:
(1)、通过create table创建外键:
看2行代码,是建表中的命令:
create table city(
......
key idx_fk_country_id (country_id),
constraint fk_city_country Foreign Key(country_id) References country(country_id) on DELETE restrict ON update cascade ON Delete cascade
)...
注:ON update cascade ON Delete cascade级联更新和级联删除。
通常在设置外链时,都会先设置