SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE a (
    id INT NOT NULL,
    PRIMARY KEY (id)
);




CREATE TABLE b (
    id INT NOT NULL,
    a INT NOT NULL,
    PRIMARY KEY (id),
    FOREIGN KEY (a) REFERENCES a (id) ON DELETE CASCADE
);

CREATE TABLE c (
    id INT NOT NULL,
    a INT NOT NULL,
    PRIMARY KEY (id),
    FOREIGN KEY (a) REFERENCES a (id) ON DELETE CASCADE
);

CREATE TABLE d (
    id INT NOT NULL,
    b INT NOT NULL,
    c INT NOT NULL,
    PRIMARY KEY (id)
   , FOREIGN KEY (id) REFERENCES b (id) ON DELETE CASCADE
   , FOREIGN KEY (id) REFERENCES c (id) ON DELETE RESTRICT
);
Msg 156 Level 15 State 1 Line 7
Incorrect syntax near the keyword 'RESTRICT'.

INSERT INTO a VALUES (1);
1 rows affected

INSERT INTO b VALUES (1, 1);
1 rows affected

INSERT INTO c VALUES (1, 1);
1 rows affected

INSERT INTO d VALUES (1, 1, 1);

Msg 208 Level 16 State 1 Line 1
Invalid object name 'd'.

select * from a;


id


1


delete FROM a;
1 rows affected

select * from a;


id