Automatically check foreign keys or enable via checkbox

little-brother / sqlite-gui

Lightweight SQLite editor for Windows

GNU General Public License v2.0

1.07k stars 51 forks source link

Automatically check foreign keys or enable via checkbox #148

Closed mpjanus closed 8 months ago

mpjanus commented 8 months ago

By default, foreign keys are not checked / enforced (although you can check for it via the tools). Via the settings -> extra tab, you can enable this by sending PRAGMA foreign_keys = ON; and reopen te connection. But this is such important functionality, that I think it should be enabled by default and made available as a checkbox item.

BTW, I love this tool (simple &lightweight), keep up the good work!

little-brother commented 8 months ago

Ok. It will be added in the next version simultaneously with the new SQLite release.

little-brother commented 8 months ago

Added.