SQLite Forum

'ON DELETE CASCADE' seems to not be working
Login
Technically this is correct.  PRIMARY KEY columns must be NOT NULL.  Except in SQLite rowid tables where PRIMARY KEY is merely syntactic sugar for UNIQUE and the actual primary key is the rowid.