title: foreign key constraint ON DELETE CASCADE not working in sqlite database on android
body: <p>I have "days" table created as follows</p>
  
  <pre><code>"create table days(" +
              "day_id  integer primary key autoincrement, " +
              "conference_id integer , " +
              "day_date text, " +
              "day_start_time text, " +
              "day_end_time text, " +
              "day_summary text, " +
              "day_description text)";
  </code></pre>
  
  <p>and i have tracks table created as follows</p>
  
  <pre><code>CREATE_TABLE_TRACK = "create table track(" +
          "track_id integer primary key autoincrement," +
          "day_id integer,"+
          "track_name text," +
          "track_description text," +
          " FOREIGN KEY(day_id) REFERENCES days(day_id) ON DELETE CASCADE )";
  </code></pre>
  
  <p>as shown above i have foreign key day_id referencing to the day_id of table days...</p>
  
  <p>So what i want is if i delete the day then corresponding track should also be deleted... But it does't happen in my case..</p>
  
  <p>I have sqlite with version <strong>3.5.9</strong></p>
  
  <p>And also i have added 1 line in my helper class as</p>
  
  <p><strong>> db.execSQL("PRAGMA foreign_keys=ON;");</strong></p>
  
  <p>but is still won't work.. please help me out..</p>