SQLite Expert Personal6.0.1

Developing SQLite databases and need an easy, powerful tool? SQLite Expert Personal is a free, feature rich administration and development tool for SQLite, designed for everyone from writing a simple query to developing a complex database.

The graphical interface supports all SQLite features: an SQL editor with syntax highlighting and code completion, and visual table and view designers.

Supported platforms: Windows 7, 8, 10 and 11.

New in version 6

* The table designer applies most changes with ALTER TABLE instead of rebuilding the table: no copying rows, and the formatting of your own DDL survives.
* Renaming a table or column carries through to every view and trigger that refers to it.
* Convert existing tables to STRICT, guided by a wizard that reads the data first.
* Light and dark themes.

Advanced SQL editor

* Syntax highlighting and code completion.
* Multiple SQL tabs.

Powerful restructure capabilities

* Visual editors for table columns, indexes, foreign keys, triggers, unique and check constraints.
* Restructure any complex table without losing data.

Data editing

* Edit data in the grid using powerful in-place editors.
* Visualize and modify BLOB fields using the integrated Hex editor.

Other features

* Full Unicode support.
* Support for attached databases.