Database Editor Features

Environment

Operating systems support Windows XP, Vista, 7, Windows 8/10 (desktop), Server 2003, 2008, 2012.

Connections

What kind of unified database interfaces are supported? ODBC (32 bit), OLE DB or Oracle Call Interface.
Does the product support desktop database formats? Yes: Access, DBF, Excel, Paradox.
Does the product support any DBMS-specific features? Yes, for Microsoft SQL Server, Oracle, DB2, Informix, Sybase, MySQL, SQLite, PostgreSQL and Interbase/Firebird.
How many connection can be established simultaneous? Up to 30-60 connections depends on database systems, available client system resources and driver(s) versions.
Does the editor allow to execute custom SQL scripts against connected database? Yes, the program has built in SQL console.

Objects Browser

Does the product support object list filtering? Yes, by mask and by name selection.
Does the product support schema cache for large scale database schemas? Yes.
Can the user exclude system database schemas like 'sys' from the object list? Yes.
Does the editor provide user with extended information about currently selected table? Yes, list of keys/indexes, triggers and check constraints.
Can the data editor operate with view and system tables? Yes, corresponding option should be switched on at the Settings window.
Can the user export object definition to SQL scripts? Yes.
What kind of operation with database objects are supported? Drop object and delete all data.

Table Data

Does the product provide table level row filtering? Yes.
Does the product support row list ordering? Yes.
Has the product built-in search feature at table row level? Yes.
What kind of row operations are supported? Update row, add new row, remove existing rows.
What kind of row navigation features are supported? First, Last, Page Up/Down, row Up/Down and direct "go to" operation by row number.
Does the product allow the user to print complete data for single row? Yes.

Assistance/Help

Is help for the tool built into the product? Yes.
Is help for the tool available online? Yes, see on-line help