Foreign key definition in sqlite

Question

Cant add foreign key constraint in sqlite ...........

Answer 1

sqlite does not enforce foreign key constraints.

Answer 2

As of SQLite 3.6.19, SQLite supports foreign keys. You need to enable them via:

sqlite> PRAGMA foreign_keys = ON;

They are turned off by default for backwards compatibility.

See the documentation for more details.