SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
PRAGMA foreign_keys = ON;
✓
CREATE TABLE IF NOT EXISTS "Places" (
    "Id" TEXT NOT NULL CONSTRAINT "PK_Places" PRIMARY KEY,
    "Name" TEXT NOT NULL
);
✓
CREATE TABLE IF NOT EXISTS "People" (
    "Id" TEXT NOT NULL CONSTRAINT "PK_People" PRIMARY KEY,
    "Name" TEXT NOT NULL,
    "HomeId" TEXT NOT NULL,
    CONSTRAINT "FK_People_Places_HomeId" FOREIGN KEY ("HomeId") REFERENCES "Places" ("Id") ON DELETE CASCADE
);
✓
INSERT INTO "Places" ("Id", "Name") VALUES 
("6f81fa78-2820-48e1-a0a7-b0b71aa38262", "Castle");
✓
INSERT INTO "People" ("Id", "HomeId", "Name") VALUES 
("ccb079ce-b477-47cf-adba-9fdac6a41718", "6f81fa78-2820-48e1-a0a7-b0b71aa38262", "Fiona");
✓
SELECT * FROM Places;


Id
Name


6f81fa78-2820-48e1-a0a7-b0b71aa38262
Castle


SELECT * FROM People;


Id
Name
HomeId


ccb079ce-b477-47cf-adba-9fdac6a41718
Fiona
6f81fa78-2820-48e1-a0a7-b0b71aa38262


DELETE FROM "Places" WHERE "Id" = "6f81fa78-2820-48e1-a0a7-b0b71aa38262";
✓
SELECT * FROM Places;


Id
Name


SELECT * FROM People;


Id
Name
HomeId