On Connect SQL Tab for SQLite Manager

Stores a list of SQL statements to be run upon opening a database in SQLite Manager

The On-Connect SQL Tab can be used to enable foreign key support for all databases by adding the following line to the text box on the tab as shown above.

PRAGMA foreign_keys=ON;

Activate support for Foreign Keys


Colin Riley --Updated January 2011--

SQLite Introduction     SQLite Site Index