SQL Edge not only allows users to execute SQL scripts, but also provides a powerful way to 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.
SQL Edge has six perspectives. The "Query Perspective" allows users to run any SQL queries and scripts. It supports Oracle PL/SQL, PostgreSQL PL/pgSQL, DB2, MySQL, SQL Anywhere Watcom SQL and Transact-SQL scripts. The "Schema Perspective" allows users to browse database schema information and create tables, views, synonyms and sequences.
The "Relationship Table View" displays data in the master-detail style. The "Relationship Tree View" displays master table records as top-level tree nodes. The nodes can be expanded to reveal any level of related detail records. In addition, clicking any node will display the corresponding data in a detail grid.
The "Model Perspective" displays tables and their relationships in ER diagrams. It supports auto-layout, outline view, and multi-page print preview.
Come to know more about: http://www.baybreezesoft.com/
Liked it! Share this Tutorial