SQLite Expert Personal 2.0.16

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    
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    
   • View triggers    
   • Supports temporary tables    
     
3. Managing views
   
   • Create views    
   • Delete views    
   • Rename views    
   • View triggers  
     
   • Supports temporary views    
     
4. Executing SQL scripts
   
   • Execute SQL scripts    
   • Stop long running queries    
   • SQL history    
   • SQL syntax highlighting    
   • Save and load SQL scripts  
     
5. 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    
     
6. Data types
   
   • 40 predefined data types    
   • Custom data types