Foreign key definition in sqlite

Question

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

score 7 · Answer 1 · answered Jun 01 '10 at 21:18

7

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.

answered Jun 01 '10 at 21:18

romandas

4,086
7
29
33

Direct link to this info: http://www.hwaci.com/sw/sqlite/foreignkeys.html#fk_enable – scorpiodawg Oct 20 '11 at 22:16

score 1 · Answer 2 · answered Jul 14 '09 at 09:46

1

sqlite does not enforce foreign key constraints.

answered Jul 14 '09 at 09:46

Darin Dimitrov

1,023,142
271
3,287
2,928

1

As romandas says, it does have foreign key support after 3.6.19. – Sean Kearon Dec 09 '10 at 12:51

score -1 · Answer 3 · edited May 08 '11 at 19:17

-1

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) ; :)

edited May 08 '11 at 19:17

Ladislav Mrnka

360,892
59
660
670

answered May 08 '11 at 07:27

thang

1

Foreign key definition in sqlite

3 Answers3

Linked