SQLite Foreign Key Enforcer (AIR) 1.0
Download
Free  

SQLite Foreign Key Enforcer (AIR) 1.0

Free FOREIGN KEY constraints are parsed but are not enforced in SQLite
Rating
Your vote:
Latest version:
1.0 See all
Screenshots
1 / 2
Freeware
Download
Free  

FOREIGN KEY constraints are parsed but are not enforced in SQLite. However, the equivalent constraint enforcement can be achieved using triggers.
Unfortunately you would have to write triggers for the Insert, Update and Delete operations for every Foreign Key in your database.
It will obviously be a tedious task prone to many human errors to create all the triggers. So I decided to write a little application that would generate these triggers after parsing some parameters to the application.

Comments

User

Your vote: