SQLite Expert 2.0.42 Build 1860

SQLite Expert 2.0.42 Build 1860 is known as a powerful administration tool for your SQL databases. SQLite Expert integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface.

Major Features:

1.   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.
2. Build SQL scripts and generate views visually using the integrated Query Builder.
3. Create SQLite3 databases, view and change database parameters, check database integrity and vacuum (compact) databases.
4. Easily transfer data between SQLite databases, import data from SQL scripts or ADO data sources, or export to SQL scripts.
5. Display and edit data in the grid, including BLOB and image fields. Currently supports BMP, JPG, PNG and GIF image formats. BLOB fields can be edited with the integrated hex editor.
6. Execute SQL queries and display results in the grid or as text.
7.  Create database
8. View and change database parameters
9. Register frequently used databases for using in SQLite Expert
10. Check integrity
11. Vacuum
12. Transaction support
13. Create tables
14. Delete tables
15. Rename tables
16. Restructure tables without losing existing data
17. View, add, delete, modify, reorder fields
18. View, add, delete, modify indexes
19. View constraints
20. View triggers
21. Supports temporary tables
22. Create views
23. Delete views
24. Rename views
25. View triggers
26. Supports temporary views
27. Execute SQL scripts
28. Stop long running queries
29. SQL history
30. SQL syntax highlighting
31. Save and load SQL scripts
32. Display and edit data in the grid
33. Display data as text
34. Limit the number of records in result set
35. Image editor (supports BMP, JPG and PNG)
36. BLOB editor
37. Text editor
38. 40 predefined data types

Enhancements

• Fixed error occurring when filtering a dataset with duplicate field names.

• Windows 2000/XP/2003/Vista