SQlite - Android - Foreign key syntax

Question

I ve been trying to get foreign keys working within my Android SQLite database  I have tried the following syntax but it gives me a force close   private static final String TASK TABLE CREATE    create table                 TASK TABLE          TASK ID                 integer primary key autoincrement      TASK TITLE                 text not null      TASK NOTES     text not null          TASK DATE TIME     text not null  FOREIGN KEY    TASK CAT    REFERENCES   CAT TABLE      CAT ID          Any ideas what I might be doing wrong  if you need to see the other table structure then I can  its just a very simple structure for the second with an ID and a name   Edit    Here is the error      03-13 13 42 35 389    ERROR AndroidRuntime 312   Caused by    android database sqlite SQLiteException    unknown column  taskCat  in foreign   key definition  create table reminders     id integer primary key   autoincrement  task title text not   null  notes text not null    reminder date time text not null    FOREIGN KEY  taskCat  REFERENCES   category   id

User · Answer

As you can see in the error description your table contains the columns   id  tast title  notes  reminder date time  and you are trying to add a foreign key from a column  taskCat  but it does not exist in your table

User · Answer

Since I cannot comment  adding this note in addition to  jethro answer   I found out that you also need to do the FOREIGN KEY line as the last part of create the table statement  otherwise you will get a syntax error when installing your app  What I mean is  you cannot do something like this   private static final String TASK TABLE CREATE    create table         TASK TABLE          TASK ID         integer primary key autoincrement      TASK TITLE         text not null      TASK NOTES     text not null      TASK CAT     integer       FOREIGN KEY    TASK CAT    REFERENCES   CAT TABLE      CAT ID         TASK DATE TIME     text not null       Where I put the TASK DATE TIME after the foreign key line

User · Answer

You have to define your TASK CAT column first and then set foreign key on it   private static final String TASK TABLE CREATE    create table             TASK TABLE                   TASK ID     integer primary key autoincrement               TASK TITLE     text not null               TASK NOTES     text not null              TASK DATE TIME     text not null             TASK CAT     integer               FOREIGN KEY    TASK CAT    REFERENCES   CAT TABLE     CAT ID          More information you can find on sqlite foreign keys doc

[android] SQlite - Android - Foreign key syntax

Examples related to android

Examples related to sqlite

Examples related to foreign-keys