The graphical interface supports all SQLite features. It includes a visual query builder, an SQL editor with syntax highlighting and code completion, visual table and view designers and powerful import and export capabilities.
Visual SQL Query Builder
- Build complex SQL queries with ease.
- Formatted SQL query text layout.
- Powerful means of SQL query parsing and analysis.
- Advanced SQL editor with syntax highlighting and code completion.
Data editing
- Edit data in the grid using powerful in-place editors.
- Image editor currently supporting JPEG, PNG, BMP, GIF and ICO image formats.
- Visualize and modify BLOB fields using the integrated Hex editor.
Powerful restructure capabilities
- Visual editors for table columns, indexes, foreign keys, triggers, unique and check constraints.
- Restructure any complex table without losing data.
- Any restructure operation is wrapped in a nested transaction which is rolled back if any errors occur when applying changes.
Import and Export data
- Import data from ADO data source, CSV files, SQL script or SQLite.
- Export data to CSV files, SQL script, Excel or SQLite.
- Copy tables between SQLite databases using drag and drop operations.
- Export data to Excel via clipboard.
Other features
- Full Unicode support.
- Support for attached databases.
- Supports SQLite extensions and third-party SQLite libraries.
- Lua and Pascal scripting support.
What's New
http://www.sqliteexpert.com/history.html
HOMEPAGE
http://www.sqliteexpert.com/