SQLitefktg

An SQLite foreign-key trigger generator
Download

SQLitefktg Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Freeware
  • Publisher Name:
  • Kuba Wroniecki
  • Operating Systems:
  • Windows All
  • File Size:
  • 197 KB

SQLitefktg Tags


SQLitefktg Description

SQLitefktg was developed to be an SQLite foreign-key trigger generator. SQLite parses and stores foreign-key constraints from the DDL statements, but does not enforce them. The SQLite foreign-key trigger generator is packaged with a simple command line utility named sqlitefk. You can use this utility to modify an existing database so its foreign key constraints are enforced. sqlitefk filename Parameters: -f – run the program without asking for user confirmation -e – followed by a comma separated list of tables to be ommited in the trigger generation -c – followed by a comma separated list of foreign-key columns to support cascade deleting ( sqlitefk -c table1.column1,table2.column2 filename ) Examples - sqlitefk database.sqlite - sqlitefk -e table1,table2 database.sqlite - sqlitefk -c table1.key1,table2.key2 -e table3,table4 database.sqlite The utility modifies the database file, and even though its actions are restricted to CREATE TRIGGER / DROP TRIGGER statements, it is highly recommended that you backup any sensitive data before running this tool.


SQLitefktg Related Software