title: Foreign key constraints in Android using SQLite? on Delete cascade
body: <p>I have two tables: tracks and waypoints, a track can have many waypoints, but a waypoint is assigned to only 1 track. </p>
  
  <p>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.</p>
  
  <p>When I delete a track I want to delete the assigned waypoints, is this possible?. I read about using Triggers but I don't think they are supported in Android.</p>
  
  <p>To create the waypoints table:</p>
  
  <pre><code>public void onCreate(SQLiteDatabase db) {
      db.execSQL( "CREATE TABLE " + TABLE_NAME 
                  + " (" 
                  + _ID         + " INTEGER PRIMARY KEY AUTOINCREMENT, " 
                  + LONGITUDE   + " INTEGER," 
                  + LATITUDE    + " INTEGER," 
                  + TIME        + " INTEGER,"
                  + TRACK_ID_FK + " INTEGER"
                  + " );"
                );
  
      ...
  }
  </code></pre>