Foreign key definition in sqlite

Question

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

Answer 1

sqlite does not enforce foreign key constraints.

Answer 2

in sqlite 3 : examples :

create table student (_id integer autoincrement primary key ,master_id integer);
create table master (_id integer autoincrement primary key , name varchar(30) );

select * from student where master_id in (select _id from master where name like '...')

Don not need foreign key (master_id) references master(_id) ; :)

Answer 3

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.