If you need to temporarily violate checks in order to rearrange your schema, I 
draw your attention to these two:

<https://www.sqlite.org/pragma.html#pragma_ignore_check_constraints>

<https://www.sqlite.org/pragma.html#pragma_foreign_keys>

Obviously, once you're done rearranging/importing you reenable them both and run

<https://www.sqlite.org/pragma.html#pragma_integrity_check>

To see what horrible things you've done to the database.

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

Reply via email to