|
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. |
|
|