SQLite Forum

'ON DELETE CASCADE' seems to not be working
Login
Chronological Hierarchical 
Only for without rowid tables.  For rowid tables PRIMARY KEY is merely syntactic sugar for UNIQUE -- except for INTEGER PRIMARY KEY which declares an explicit name for the rowid.