SQLite Expert is a powerful tool designed to simplify the development of SQLite3 databases. It is a feature rich administration and development tool for SQLite designed to answer the needs of all users from writing simple SQL queries to developing complex databases.
FEATURES –
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.
- Total size 200.1 MB