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