> Most DBMS's implement immediate Foreign-Keys by default, unlike SQLite. > With deferred FKs, the only mode in SQLite... No, immediate is the default and you have to specify "deferrable initially deferred" to get deferred FKs. [Deferred Foreign Key Constraints](https://www.sqlite.org/foreignkeys.html#fk_deferred) (Or I'm just misunderstanding what you're saying)