Editing SQLite Cookbook (section)

=== `ON DELETE CASCADE` ===

Sqlite3 turns off foreign key support by default. With foreign key support off even when a table definition specifies `ON DELETE CASCADE` the rows in the foreign key tables will not be deleted.<ref>[https://stackoverflow.com/questions/15301643/sqlite3-forgets-to-use-foreign-keys SQLite3 forgets to use foreign keys]&mdash;StackOverflow</ref>

Before each command where foreign key support is needed it's necessary to issue the following command: `PRAGMA foreign_keys = ON;`

==== Turning on FK support by default ====

To turn on foreign key support by default, add the following line to the sqlite configuration file, `~/.sqliterc`:

<pre>
PRAGMA foreign_keys = ON;
</pre>

==== pyCharm ====

* Right click on the database connection > '''Properties'''
* '''Advanced''' tab > `foreign_keys` option: `true`

''N.B. I tried this with no effect, e.g. tested some code that deleted a record with FKs that were not deleted along with it.''