Detailed Description of Aglowsoft SQL Query Tools 5.6.0

Aglowsoft SQL Query Tools is the key product developed by Aglowsoft. It includes 3 database tools. They are Aglowsoft Schema Tool, Aglowsoft Designer, and Aglowsoft Browser. The tools are designed to allow building of SQL queries with basic knowledge of SQL using user friendly interface. 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.

A key feature of Aglowsoft SQL Query Tools is the ability to 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 works with any OLE DB and ODBC-compliant database. 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.

Aglowsoft Schema Tool is a component of Aglowsoft SQL Query Tools. It is a database tool used for capturing the meta data from OLE DB and ODBC databases. Aglowsoft Schema Tool also allows the user to improve and manage the information in the meta data that has been captured. The extracted schema is saved to a file which is called SHM (Schema ) file. User can further refine the captured meta data by defining primary keys, entity relationships, and column aliases. Nothing is changed in the given OLE DB or ODBC data source as the extracted and refined schema data are saved to external SHM (Schema) file. The table columns, primary keys, relationships, and column aliases will be used by Aglowsoft Designer to build SQL queries.

TAGS OF AGLOWSOFT SQL QUERY TOOLS

html tools , mp3 repir tools , rc tools v3 , spreadsheet tools , daemon tools , flyspeed sql query , rctools v5.1 , code blocks tools , pc tools