Previous Topic

Next Topic

Book Contents

Book Index

Database Explorer

Once you sign onto a database, you will be shown the Database Explorer window. This shows you all the objects in your database.

What you see in this window will depend on the type of database you are connecting to, and how AQT has been customized . . . the following description is generic, to give a general guide.

DB Explorer v10

The Database Explorer has three panes:

Notes:

Using the Object Tree

The object tree shows the different types of objects in your database (Tables, View etc), each represented by a particular icon.

If the object tree shows you only “Tables and Views” and “System Tables” then either you are using a database which doesn’t have system tables (eg. Access) or you have not enabled the system-table query feature. This setting is controlled by Options > General > Table Information > Get Table Information from.

Showing Objects, Favorites or Queries

The left pane of the Database Explorer window can show either Objects (as per the above screen-shot), Favorites or Queries. Click on the toolbar buttons Objects / Favorites / Queries to select what is shown in this pane.

If you select neither, the left pane will not be shown. This can be useful for increasing the screen real-estate.

Using the Object List

The Object List shows all the objects within the schema that you selected in the object tree.

Clicking on an object in the Object List will display the details of that object in the Object Details display.

Using the Object Details

Using the Administration Toolbar

If the Administration Component is active for your database, you will see the Administration Toolbar at the top of the Object List in the middle grid. Once you click on an object, this toolbar will display a number of icons. You may or may not see all these icons, depending on how the Administration Component has been configured for your database.

The create object icon will always be active. The other icons will only be active once you have clicked on an object. Depending on what type of object you have clicked on (table, view etc), different icons will be displayed.

Other Database Explorer functions

Object List and Object Details displays

The section How to use Grids in AQT explains many useful functions available in the grids. Others are explained below.

Copying

You can copy the contents of a number of cells by selecting the cells then hitting Ctrl+C or the Copy icon. This is useful to (for instance) copy the names of all your tables (to the clipboard). You can do more advanced copying with the Text Generator feature.

Other displays

These displays require further explanation, available from the links.

Other menu items

Advanced Query Tool
https://www.querytool.com
© 2023 Cardett Associates Ltd. All rights reserved.