Sample Header Ad - 728x90

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