On Mon, 04 Apr 2016 17:51:30 +0200 Domingo Alvarez Duarte wrote: >FOREIGN KEY constraint failed
>I have some databases with lots of foreign keys and I sometimes I need to >change the structure of some tables and I get this message Before restructuring a database schema always use: PRAGMA foreign_keys = OFF; After restructuring is executed successfully you can test the result by querying with this pragma ON. http://sqlite.org/pragma.html#pragma_foreign_keys Kind regards/Vriendelijke groeten. Klaas `Z4us` Van B., CEO/CIO LI#437429414
