On Wed, 19 Dec 2012 21:10:28 -0500, Richard Hipp <d...@sqlite.org> wrote:

> The latest SQLite from trunk (not the 3.7.15.1 patch release,
> but the code that is destined to become 3.7.16) has a new pragma:
>
>    PRAGMA foreign_key_check;
>    PRAGMA foreign_key_check(TABLE);
>
> The second from checks all of the REFERENCES clauses in TABLE.
> The first form checks the keys on all tables in the database.
>
[....]
>
> PRAGMA foreign_key_check works regardless of whether or not
> foreign keys are currently enabled or disabled.

Perfect, thanks!

-- 
Groet, Cordialement, Pozdrawiam, Regards,

Kees Nuyt

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to