Enable foreign keys on Sqlite3 version 3.5.9

Question

I'm trying to enable foreign keys on a sqlite3 database doing this:

sqlite> PRAGMA foreign_keys=ON;

But it doen't work.

How can I do it?

Note: the database is on an Android device.

Thanks.

This statement only works since sqlite version 3.6.19. – VansFannel Oct 21 '10 at 12:48 — VansFannel, Oct 21 '10 at 12:48

score 0 · Answer 1 · edited May 23 '17 at 11:57

0

Sqlite3 supports foreign keys only as of version 3.6.19 http://www.sqlite.org/foreignkeys.html

UPDATE

Version of SQLite used in Android?

edited May 23 '17 at 11:57

Community

answered Apr 28 '13 at 05:05

Sergey Markelov

1 Answers1