SQL Edge not only allows users to execute SQL queries, 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. Besides query view and schema view, SQL Edge has two relationship views. 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. SQL Edge also has a model view to display tables and their relationships in ER diagrams. SQL Edge supports Oracle, MySQL, Microsoft SQL Server and any JDBC compliant databases. Note: please register at developer website to obtain the free trial license key.
See also: ER diagrams, master-detail relationship, SQL query
|
Software Crown
