Choose your database:

Partners

Testimonials

Ron D.: "I'm still very happy with SQLite Maestro and Data Wizard; makes my HTPC database much easier to manage".

Mark Worsnop: "By the way I wanted to say thank you for a good software package. It's a pleasure to work with Maestro as it "just works" and makes my job that much easier".

Add your opinion

Customers

Become a customer

SQL Maestro Group / Products / SQLite / SQLite Maestro / Documentation

Download

Buy

SQLite Maestro online Help

Return to chapter overview

Specify SQLite connection properties to be used on further connections.

Enable native foreign key support

This option affects the automatic creation of referential integrity triggers: they are NOT created if it is turned ON and vice versa. Foreign keys are supported by SQLite 3.6.19 and higher.

Return to chapter overview

Company news

May 5, 2021

SQLite Maestro 21.5 released

New version introduces new database encryption algorithms, support for generated columns, support for renaming and dropping columns using ALTER TABLE statement, and some other enhancements.

Nov 14, 2016

SQLite Maestro 16.11 released

New version introduces support for FTS5 extension and expression-based indexes, new encryption algorithms in data grids, updated data export and data import tools, and some other useful things.

Jan 12, 2015

SQLite Maestro 15.1 released

New version comes with support of user authentication and management, read-only database connections, colored tabs, and some other new features.

More news

Feature of the day

Multiple Operations

You can select several database objects in the Object Manager of SQLite Maestro to perform the same operation upon all of them at a time.

Object Duplicating

You can make a copy of a database object by dragging it from one database to another in SQLite Maestro.

SQLite Maestro online Help

Setting connection properties