Advanced Query Tool

Database Explorer

When you sign onto a database, AQT will show you a Database Explorer with all the objects in your database:

  • You can sign onto multiple databases. In the example below, AQT is signed onto DB2/UDB, Oracle, SQL Server and MS Access.
  • You see not only information on Tables and Views, but also Tablespaces, Indexes, Trigger, Procedures, Functions etc.
  • AQT's unique three-panel format makes it efficient to navigate around a database with a large number of objects. Some of our customers have systems with over 400,000 tables.
  • The buttons at the bottom of the window show you the windows you have open. Go to another window by clicking on one of these buttons. It is very easy to navigate between the open windows in AQT.
Database Explorer

Database information

AQT shows a lot of information about your Database

  • Right-clicking an object (as in the screenshot below) will show you the other information you can display about an object.
  • Behind this window are over 150 system queries; AQT shows you more information about your database than the vendor-supplied tools.
  • The information shown in this window is governed by a configuration file; this has been configured individually for each database type. If necessary, you can amend this config file to display additional information, or to restrict the information seen by your users. This gives AQT an impressive degree of customizability.
Database Explorer


AQT allows you to define and use Favorite database objects

  • Allows you to group your objects by application, or some other useful grouping.
  • Objects of different types can be grouped in the same Favorites folder.
  • Queries, charts and saved-results can be defined as Favorites.
  • Can add your own description of the objects.
  Go Home Go to Top

Last reviewed on 17 May 2011   

Copyright 2002-2011 Cardett Associates Ltd. All rights reserved.