SQL Edge™ is a SQL query tool that allows users to execute SQL queries, browse schema information in ER diagrams, and visualize data relationships. With SQL Edge™, users can use only one query to retrieve data in a master table, and then browse data in all related detail tables. Users can also insert, edit, and delete table records in the data grids.

Please refer to http://www.baybreezesoft.com for product details.

The version 2.1 added following features:

1) For Oracle databases, the SQL editor allows users to execute anonymous PL/SQL blocks and create triggers, stored procedures and packages. The SQL editor also supports annotation of PL/SQL compilation errors.

2) For Oracle databases, the schema perspective displays script information for triggers, sequences, stored procedures, and packages.

3) Support saving ER-diagrams in JPEG file format.


The following are the version 2.0 features:

1) Support Oracle, Microsoft SQL Server, MySQL, PostgreSQL, and any JDBC compatible databases.

2) Support Windows, Linux and Mac OSX operating systems.

3) Allow users to specify JDBC drivers at run-time, and provide wizards to help setup JDBC connections. Easy to install, and easy to setup.

4) SQL editor with syntax highlighting and SQL statement formatting.

5) SQL edtior allows users to execute SQL queries asynchronously. Users can cancel the execution by click the "Cancel" button or just close the SQL Editor.

6) Supports running SQL scripts. The SQL editor can run a script and display results in multiple query result windows if there are more than one select statements in the script.

7) Supports editable query result window. The data grid of the query result window is editable if all selected columns are from one table and also include the primary key of the table.

8) Schema perspective displays the table schema information, including column definitions, primary key, indexes, and foreign keys.

9) Relationship table view displays the related data in the master-detail style, with master table data shown in the top grid, and all related detail table data in a list of bottom grids.

10) Relationship tree view displays the master table records as top-level tree nodes, and the related detail records as child nodes. Click any of these tree nodes will display the corresponding record data in a detail grid.

11) Allow users to insert, edit, and delete records in the master and detail grids of the relationship table view and relationship tree view.

12) Allow users to define master-detail relationships even between tables in different databases. This enables the relationship table view and relationship tree view to display data relationships between tables in different databases or without pre-defined foreign keys.

13) Model perspective displays tables and their relationships in ER diagrams. The tables can be from different databases. Users can define master-detail relationships among these tables, and print or save the diagram for future reference.

14) Execution plan perspective displays the execution plan of a query. It supports Oracle and PostgreSQL execution plans.