Foreign key constraints in Android using SQLite? on Delete cascade

by

Foreign key constraints with on delete cascade are supported, but you need to enable them.
I just added the following to my SQLOpenHelper, which seems to do the trick.

@Override
public void onOpen(SQLiteDatabase db) {
    super.onOpen(db);
    if (!db.isReadOnly()) {
        // Enable foreign key constraints
        db.execSQL("PRAGMA foreign_keys=ON;");
    }
}

I declared my referencing column as follows.

mailbox_id INTEGER REFERENCES mailboxes ON DELETE CASCADE

More Related Contents:

  1. Can’t add parameter ‘this’
  2. How to use an existing database with an Android application [duplicate]
  3. SQlite Getting nearest locations (with latitude and longitude)
  4. Any good ORM tools for Android development? [closed]
  5. Simple export and import of a SQLite database on Android
  6. SQLite in Android How to update a specific row
  7. Using Singleton design pattern for SQLiteDatabase
  8. Database not copying from assets
  9. Android search with Fragments
  10. Which Android Data Storage Technique to use?
  11. Get generated id after insert
  12. How to persist permission in android API 19 (KitKat)?
  13. Upgrade SQLite database from one version to another?
  14. Android: Cannot perform this operation because the connection pool has been closed
  15. SQLiteOpenHelper failing to call onCreate?
  16. What is the use of BaseColumns in Android
  17. What is the correct way to do inserts/updates/deletes in Android SQLiteDatabase using a query string?
  18. Android : Table has no column named “variable name” MySql Database error
  19. How do you enforce foreign key constraints in SQLite through Java?
  20. android.database.sqlite.SQLiteException: no such column
  21. UNIQUE constraint failed: sqlite database : android
  22. How To Test If Cursor Is Empty in a SQLiteDatabase Query
  23. android.database.CursorWindowAllocationException when moving a Cursor
  24. Read data from SQLite where column name contains spaces
  25. Is it OK to have one instance of SQLiteOpenHelper shared by all Activities in an Android application?
  26. Clickable widgets in android
  27. App crashing when trying to use RecyclerView on android 5.0
  28. How to disable spelling corrections programmatically in Android
  29. android admob resize on landscape
  30. Using the camera activity in Android

Leave a Comment