Description

Build SQL queries with three database tools--Aglowsoft Schema Tool, Aglowsoft Designer and Aglowsoft Browser. Result sets from SQL queries are presented in a combination form of tree views and table views. Tree view can be printed or exported to an XML file or an LDIF file, and table view can be exported to ODBC database table, Access 2000 database, XML or HTML format.

You can build SQL queries in the form of view definition tree, where a path in the view definition tree discloses relationships between data from different tables. Aglowsoft SQL Query Tools supports ODBC databases. SQL statements supported include select, insert, update and delete. The program includes Unicode support, support for ANSI inner and outer joins, entity relationship diagram, and DDL Generation for relationships. Version 4.2 manipulates relationships with more than one foreign key column as one entity to resolve ambiguity and improve performance.