Foreign Key Enforcement on ALTER TABLE ADD COLUMN – Current State and Unresolved Behavior
Goal Determine how SQLite’s foreign key enforcement behaves when a new constraint is added via ALTER TABLE … ADD COLUMN on a database where PRAGMA foreign_keys = ON is active. Constraints & Uncertainty SQLite 3.x – foreign key enforcement is disabled by default and must be enabled per connection. Existing data may already violate the new foreign key cons
sqlite