How to set "PRAGMA foreign_keys = ON" each time I'm connecting to sqlite db via Datagrip
2
votes
2
answers
1714
views
In my pet project I'm working with small sqlite db and I've just came to realization that, in order to
ON DELETE CASCADE
actually do the thing, I need to set PRAGMA foreign_keys = ON
each time I'm connecting to db.
However I'm using Datagrip and since it's quite new product to me I don't what's the best way to set this option every time.
Asked by shabunc
(767 rep)
Jun 30, 2019, 06:58 PM
Last activity: Jul 1, 2019, 09:09 AM
Last activity: Jul 1, 2019, 09:09 AM