Introduction to Relational Databases in SQL
Timo Grossenbacher
Data Journalist
Referential integrity from table A to table B is violated...
CREATE TABLE a (
id integer PRIMARY KEY,
column_a varchar(64),
...,
b_id integer REFERENCES b (id) ON DELETE NO ACTION
);
CREATE TABLE a (
id integer PRIMARY KEY,
column_a varchar(64),
...,
b_id integer REFERENCES b (id) ON DELETE CASCADE
);
ON DELETE...
Introduction to Relational Databases in SQL