SQLite Expert is a powerful visual tool that enables you to easily administer your SQLite3 databases.SQLite Expert integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface.
Here are some key features of SQLite Expert :
· Create database
· View and change database parameters
· Register frequently used databases for using in SQLite Expert
· Check integrity
· Vacuum
· Transaction support
· 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
· View triggers
· Supports temporary tables
· Create views
· Delete views
· Rename views
· View triggers
· Supports temporary views
· Execute SQL scripts
· Stop long running queries
· SQL history
· SQL syntax highlighting
· Save and load SQL scripts
· Display and edit data in the grid
· Display data as text
· Limit the number of records in result set
· Image editor (supports BMP, JPG and PNG)
· BLOB editor
· Text editor
· 40 predefined data types