Create table with foreign key in sqlite

Question

I am using sqlite tool of Mozilla Firefox to manage my database and i have to create a table in which i have to use foreign key . How to do that?
These are my tables,

Table Name:QuestionWithAnswer

Column_Name=Format:
Date=DATETIME(Primary Key),
Question=Text,
Answer=Text,
UserAnswer=Text,
isCorrext=Text.

Table Name:Question
Column_Name=Format:
Question_ID=Integer(Primary Key)
Question=Text


Table Name:Record
Column_Name=Format:
id=integer(Primary Key)
DatewithTime=DATETIME(foreign key from QuestionWithAnswer)
UserAnswer=TEXT
isCorrect=BOOl
Question_ID=integer(foreign key from Question)

Above are my given tables with columns and i want to create 3rd table names Record by using foreign key. This is my create stmt

  TABLE Records
(
  id     INTEGER PRIMARY KEY, 
  DateWithTime   DATETIME, 
  UserAnswer TEXT,
  isCorrect TEXT,
  Question_ID TEXT

  FOREIGN KEY(DateWithTime) REFERENCES QuestionWithAnswer(Date),
  FOREIGN KEY(Question_ID) REFERENCES Question(question_ID),
);

but it is giving me error as " QLiteManager: Likely SQL syntax error: CREATE TABLE Records ( id INTEGER PRIMARY KEY, DateWithTime DATETIME, UserAnswer TEXT, isCorrect TEXT, Question_ID TEXT

FOREIGN KEY(DateWithTime) REFERENCES QuestionWithAnswer(Date), FOREIGN KEY(Question_ID) REFERENCES Question(question_ID), ); [ near "FOREIGN": syntax error ] Exception Name: NS_ERROR_FAILURE Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement] ".

Just execute the correct CREATE TABLE statement. What is the problem? — CL.
– CL., Commented Aug 4, 2014 at 9:32

laalto · Accepted Answer · 2014-08-04 09:39:57Z

1

Some errors in the syntax:

Add a , before the first FOREIGN KEY table constraint.
Remove the , before the closing ) paren.

answered Aug 4, 2014 at 9:39

laalto

153k68 gold badges293 silver badges306 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sandro rokho · Accepted Answer · 2019-07-01 10:41:58Z

0

after you define your attribut, add this following code

FOREIGN KEY (colonne_name) REFERENCES parent_table_name(colonne_name)

answered Jul 1, 2019 at 10:41

Sandro rokho

34 bronze badges

Collectives™ on Stack Overflow

Create table with foreign key in sqlite

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related