Installation

Connect to Database

• Download JDBC driver file(s)
• Create database connection
• Sample Database connections

Database Browser

• Browse table Information
• Browse view information
• Browse index information
• Browse trigger information
• Browse constraint information
• Browse function information
• Browse procedure information
• Browse sequence information

Database Tools

• Create, alter, rename, truncate and drop table
• Create, alter, rename and drop view
• Create, alter, rename and drop indexe
• Create, alter, rename and drop trigger
• Create and drop constraint
• Create, alter, rename and drop function
• Create, alter, rename and drop procedure
• Create and drop sequence

Data Management

• Edit table data including binary/BLOB and CLOB data types
• Format table data according to data type pattern
• Filter, sort and search query result
• Insert, update, delete, restore table data
• Find and replace data, preview generated SQL

SQL Tools

• Format SQL scripts according to customization options
• Execute SQL in one statement
• Execute SQL in multiple statements
• Execute SQL at cursor position (or selected SQL)
• Display SQL query history
• Print editor content and query table results

SQL Builder

• Build select SQL script
• Build insert SQL script
• Build update SQL script
• Build delete SQL script

Import Data

Export Data

Supported Database

• Cache
• DB2
• Derby
• Firebird
• FrontBase
• H2
• HSQLDB
• Informix
• Ingres
• JDatastore
• MaxDB
• Mckoi
• Mimer
• MySQL
• Oracle
• PointBase
• PostgresSQL
• Solid
• SQLite
• SQL Server
• SQL Anywhere
• Sybase (ASE)