Product Editions

Accessing different types of databases

Table browsing

Editing data

Searching and replacing text in database with ability to choose fields, record range etc.

Importing data to a table from another table or a database query result

Exporting data from open table or query to large number of file formats like text, CSV, HTML, JSON, XLS, XLSX, ODS, XML, RTF, DBF or to any of supported database formats

Duplicating tables and other database objects

Basic command line support

Basic printing data

Creating tables

Building and executing SQL queries

Execution of multi-statement SQL scripts

Syntax highlighting in SQL editor

Support for parameterized SQL queries

Storing database and SQL query execution history

Enhanced database grids, which allow to view and manipulate the data in the most convenient way, including sorting by clicking column header, changing row heights, resizing columns etc.

Copying data to clipboard

Calculating numeric fields (sum, avg, min, max, count)

Viewing and editing BLOB data, such as MEMO, CLOB, graphic, RTF

Batch editing text fields (trimming, changing case of symbols, replacing text)

Sorting (logical and physical) data

Filtering data according to user's criteria

Viewing table and database structure with ability to print, copy, and save it

Reindexing tables

Customized data view (font, background)

Conditional formatting data

Ability to control transactions manually

Interface to work with database objects' descriptions

Command line support: executing queries, opening tables, export and import operations, loading reports etc. with logging the performed operations

Enhanced printing abilities: built-in report engine, which allows to produce the reports automatically or by using a visual report designer with templates, expressions, preview, conditional formatting etc.