License Features
|
|
Perm |
Free |
Supported Databases
Cache, DB2, Derby / JavaDB, Firebird, FrontBase, H2, HSQLDB, Informix,
Ingres, JDatastore, MariaDB, MaxDB, Mckoi, Mimer, MySQL, MongoDb,
Oracle, Pervasive, Pointbase, PostgreSQL, Solid, SQlite, SQL Server,
Sybase SQL Anywhere, Sybase Adaptive Server Enterprise (ASE) |
|
|
|
Database Browser
|
|
|
|
Table data and row count |
|
|
|
Table information, grants,
DDL, ER-Diagram |
|
|
- |
Table columns, indexes, constraints
and triggers |
|
|
- |
View data and row count |
|
|
|
View information, grants,
DDL, ER-Diagram |
|
|
- |
Index information |
|
|
|
Index grants and DDL |
|
|
- |
Function information |
|
|
|
Function grants and DDL |
|
|
- |
Procedure information |
|
|
|
Procedure grants and DDL |
|
|
- |
Trigger information and DDL |
|
|
- |
Constraint information and
related columns |
|
|
- |
Sequence information, grants
and DDL |
|
|
- |
User information |
|
|
- |
Alias information |
|
|
- |
Other database specified objects
like tablespace, packages and so on |
|
|
- |
Database Tools
|
|
|
|
Create, alter, rename, truncate
and Drop Tables
Add, rename and drop Columns
Change column data types
|
|
|
- |
Create, alter, rename and
drop Views |
|
|
- |
Create, alter, rename and
drop Indexes |
|
|
- |
Create, alter, rename and
drop Triggers |
|
|
- |
Create, alter, rename and
drop Procedures |
|
|
- |
Create, alter, rename and
drop Functions |
|
|
- |
Create and drop Constraints |
|
|
- |
Create and drop Sequences |
|
|
- |
Database Management Tools
|
|
|
|
Edit database table data including
binary/BLOB and CLOB data types. |
|
|
- |
Format database table data
according to applied integer, timestamp, binary/BLOB, CLOB and boolean
pattern |
|
|
- |
Filter, sort and search query
result |
|
|
- |
Insert, duplicate, update,
and delete table data |
|
|
- |
Find and replace data, preview
generated SQL |
|
|
- |
Restore deleted database table
rows before update is commit |
|
|
- |
Redo or undo database table
data changes before commit |
|
|
- |
SQL Tools
|
|
|
|
Format SQL scripts according
to customization options |
|
|
- |
Support SQL variables bound |
|
|
- |
Support Execute SQL In a single
statement |
|
|
|
Support Execute SQL In multiple
SQL statements, Statement at cursor position and Selected text as
a single SQL statement |
|
|
- |
Sort and filter database query
results |
|
|
- |
Display SQL query history |
|
|
- |
Print editor content and query
database table results |
|
|
|
SQL Builder
|
|
|
|
Help tools to to build Select,
Insert, Update and Delete scripts of most databases |
|
|
- |
Import Data
|
|
|
|
Import database data from
various formats: CSV, Excel, SQL and Fixed-width files |
|
|
- |
Parse import database data
according to integer, date, time, timestamp, and boolean pattern |
|
|
- |
Export Data
|
|
|
|
Export data (single table/multiple
tables/query result) in various formats: CSV, Excel, XML, , HTML,
SQL and Fixed-width files |
|
|
- |
Format export data according
to applied integer, date, time, timestamp, and boolean pattern |
|
|
- |
Built-In Database
|
|
|
|
Built-In Database (HSQLDB)
is included in the application without any configuration |
|
|
|
Price |
|
$69.99 |
free |
|
|
|
|