SQLite Forum

'ON DELETE CASCADE' seems to not be working
> My expectation now is that when deleting player '1' from table 'players', the group assignment for player '1' in 'game_group_members' should be deleted as well, due to the 'ON DELETE CASCADE' constraint.

The *enforcement* of foreign keys is *off* by default (IIRC, for historical compatibility reasons). It can be turned on, however: