Database Objects Explorer

• Database connection wizard
• Supports multiple simultaneous database connections
• Connect to a database with a single click
• Database objects explorer
• View information for tables, indexes, primary keys, privileges, schemas, databases, procedures and a lot more
• View referential integrity rules in a graph or list

Table Support

• Table data filtering
• Display references to other tables
• Monitor row count differences

SQL Editor

• Syntax colored SQL editor
• SQL history saved between sessions
• Advanced SQL bookmark functionality
• Sort by clicking column header
• Parameterized SQL queries
• Drop objects dragged from the Objects Tree
• SQL execution logging with filtering options
• Pre-defined key maps
• Oracle: Support for the XML data type

Referential Integrity Graphs

• Extensive collection of tool properties
• Configurable key bindings with pre-defined key maps
• Customize the format of Date, Time and Numbers
• Look & Feels for Windows, Mac, UNIX, cross platform
• Set fonts
• Set unique properties per database connection

Monitor

• Instant Monitor of results from SQL queries
• Automatic monitoring of any result set SQL
• Print and export monitored data

General

• Dynamic JDBC driver management
• Grid support: sorting, fitting, column layout, resizing

Supported databases

• DB2 UDB
• Informix
• JavaDB/Derby
• Mimer
• MySQL
• Oracle
• PostgreSQL
• SQL Server
• Sybase ASE
• Cache
• DaffodilDB
• FrontBase
• HSQL
• JDataStore
• MaxDB
• Pervasive
• Pointbase
• Sybase ASA