Avalon SQL Editor is a software solution designed for database developers. Its mission is to develop low-cost, reliable and useful SQL editor.

Currently, Avalon SQL Editor supports:
· Microsoft SQL Server
· Oracle
· HSQLDB
· MySQL
· PostgreSQL

Drivers for Firebird, Derby and DB2 are being developed.

Here are some key features of "Avalon SQL Editor":

Database objects (tables, etc.) tree with their properties shown
SQL Editor with syntax highlighting, code completion, word casing and more
Result Pane with export
Code Completion of:
· SQL reserved words
· Database tables
· Database types
· Templates
Syntax highlighting of:
· SQL reserved words
· Database types
Automatic keyword casing (upper/lower/first letter case)
Word casing (upper/lower case)
Transaction control
Executing of selection
Multiple connections (to different databases) supported
Database objects with their properties shown
· Tables
· Table Columns
· Primary Keys
· Index Keys
· Unique Keys
Operations on database objects supported
· View Data of a table
· Delete table
Result Pane
· Selection of row(s)
· Selection of column(s)
· Coping selection (tab separated)


Requirements:

· Java 1.5 or greater version is required


Limitations:

· Nag screen
· 7 days trial period

What's New in This Release: [ read full changelog ]

· Improved user experience
· DB2 Feature Added
· Firebird Feature Added
· Derby Feature Added