---

Propagating changes

1. Enable PRAGMA foreign_keys = ON
2. Add k PRIMARY KEY to the parent table t ⁴⁰
3. Add FOREIGN KEY(k) REFERENCES t(k) to the child table
4. Optionally specify
   • FOREIGN KEY … ON DELETE action
   • FOREIGN KEY … ON UPDATE action

   with action being one of:

   • RESTRICT
   • SET NULL
   • SET DEFAULT
   • CASCADE