On 13 Dec 2015, at 12:52pm, R Smith <rsmith at rsweb.co.za> wrote: > I don't think there would be a point of turning off FK checks, adding > non-relation data to the tables, then turning it back on, and simply get a > permanent error condition.
Agreed. There is a reason to turn the checks off, however. Suppose you want to change the rows and columns of a table. Because SQLite lacks "ALTER TABLE DROP COLUMN" and "ALTER TABLE RENAME COLUMN" commands you have to create a new table and eventually move all references to it. You can'd do that without the ability to disable FOREIGN KEYs for a while. Simon.
