SQLite Expert Professional 2.0.19

• Edit tables and views visually, without writing a line of SQL. Easily restructure fields, indexes, constraints, triggers without losing data already existing in the tables.
• Build SQL scripts and generate views visually using the integrated Query Builder.
• Create SQLite3 databases, view and change database parameters, check database integrity and vacuum (compact) databases.
• Easily transfer data between SQLite databases, import data from SQL scripts or ADO data sources, or export to SQL scripts.
• Display and edit data in the grid, including BLOB and image fields. Currently supports BMP, JPG and PNG image formats. BLOB fields can be edited with the integrated hex editor.
• Execute SQL queries and display results in the grid or as text.

Major Features:

1. Managing SQLite3 databases
   • Create database 
   • View and change database parameters
   • Register frequently used databases for using in SQLite Expert
   • Check integrity
   • Vacuum
   • Transaction support
   • View database schema report
   • Export to Excel
   • Export to XML
   • Import and export from and to text files (CSV, TSV)
   • Import data from ADO data source
   • Transfer data between SQLite databases
   • Export data to script
2. Managing tables
   • Create tables
   • Delete tables
   • Rename tables
   • Restructure tables without losing existing data
   • View, add, delete, modify, reorder fields
   • View, add, delete, modify indexes
   • View constraints
   • Add, delete, modify constraints
   • View triggers
   • Add, delete, modify triggers
   • Supports temporary tables
3. Managing views
   • Create views
   • Delete views
   • Rename views
   • View triggers
   • Add, delete, modify triggers
4. Executing SQL scripts
   • Execute SQL scripts
   • Stop long running queries
   • SQL history
   • SQL syntax highlighting
   • Save and load SQL scripts
5. Query Builder
   • Completely visual building of complex SQL queries
   • User-friendly interface with drag & drop support
   • Visual building of sub-queries and unions
   • Visual criteria constructing tool for Where and Having clauses
   • Save and load SQL scripts
6. Displaying and editing data
   • Display and edit data in the grid
   • Display data as text
   • Data filtering
   • Image editor (supports BMP, JPG and PNG)
   • BLOB editor
   • Text editor
   • Generate HTML Reports
7. Extending SQLite Expert using scripting
   • Lua scripting support
   • Pascal scripting support
   • Lua and Pascal example scripts
8. Data types
   • 40 predefined data types
   • Custom data types