| Manage SQLite3 databases: create database, view/change parameters. |
|
|
| Repair damaged databases. |
|
|
| Database DDL compare tool. |
|
|
| Online backup of databases. |
|
|
| Check integrity, reindex all tables, transaction support. |
|
|
| Supports attached databases and SQLite extensions. |
|
|
| Manage tables: create, delete, rename, reindex. |
|
|
| Restructure tables: fields, indexes, foreign keys, unique and check constraints, triggers. |
|
|
| Manage views: create, delete, rename, restructure. Manage view triggers. |
|
|
| Supports temporary tables and views. |
|
|
| Supports virtual tables including RTREE, FTS3 and FTS4. |
|
|
| Includes ICU extension. |
|
|
| Advanced SQL editor with code completion and syntax highlighting. |
|
|
| Multiple SQL tabs. |
|
|
| Advanced data editing capabilities in the grid: image, BLOB and text editors. |
|
|
| Custom and predefined data types. |
|
|
| Copy/Paste records between tables via clipboard. |
|
|
| Copy/Paste tables between databases via clipboard. |
|
|
| Full Unicode support. |
|
|
| Customize the look and feel of the application using skins. |
|
|
| Visual SQL Query Builder. |
|
|
| Copy tables between databases using drag and drop. |
|
|
| Supports password protected databases (requires third party SQLite library - not included). |
|
|
| Supports SQLite auto extensions. |
|
|
| Export data to Excel, XML, JSON, HTML, CSV, TSV, ADO data sources, SQL script, SQLite database. |
|
|
| Import data from ADO data source, SQL script, SQLite, CSV, TSV. |
|
|
| Send the contents of any grid to printer or export it to a PDF file. |
|
|
| Generate SELECT, INSERT, UPDATE and DELETE statements based on the visible fields on the current table. |
|
|
| Lua and Pascal scripting support. |
|
|
