On Sun, Dec 13, 2015 at 1:17 PM, Cecil Westerhof <cldwesterhof at gmail.com>
wrote:

> At the moment I am working with Foreign Keys. They need to be enabled. When
> you do not do this it is possible to enter records that break the Foreign
> Key rules. Is there a way to check for this.
>
> For example in a session where Foreign Keys where not enabled I did the
> first INSERT from:
>     https://www.sqlite.org/foreignkeys.html
>
> When opening the database in a session with Foreign Keys enabled, is there
> a method to find this record that breaks the rules?


https://www.sqlite.org/pragma.html#pragma_foreign_key_check --DD

Reply via email to