SQLite Foreign Key Enforcer (AIR)
License:Freeware
Total downloads:14
Latest version:1.0
Description
SQLite Foreign Key Enforcer (AIR) 1.0 was available to download from the developer's website when we last checked. We cannot confirm if there is a free download of this software available. The tool is sometimes referred to as "SQLite Foreign Key Enforcer AIR".
The following version: 1.0 is the most frequently downloaded one by the program users. According to the results of the Google Safe Browsing check, the developer's site is safe. Despite this, we recommend checking the downloaded files with any free antivirus software. The actual developer of the free software is SQLite Foreign Key Enforcer. SQLite Foreign Key Enforcer (AIR) lies within Development Tools, more precisely Database Tools.
From the developer:
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.
You may want to check out more software, such as DBSync for SQLite and MSSQL, SQLite Studio or DB Browser for SQLite, which might be similar to SQLite Foreign Key Enforcer (AIR).
Comments
Subscribe to commentsPlease add a comment explaining the reasoning behind your vote.