Foreign key constraints in Android using SQLite? on Delete cascade.
- by LordSnoutimus
I have two tables: tracks and waypoints, a track can have many waypoints, but a waypoint is assigned to only 1 track.
In the way points table I have a column called "trackidfk" which inserts the track_ID once a track is made, however I have not setup Foreign Key constraints on this column.
When I delete a track I want to delete the assigned…