Actions on multiple objects

This window is used for running actions on multiple objects. Open this window from the Database Explorer, by using the buttons in the Admin toolbar such as Drop, Rename, Table Comments, or other functions.

This window is part of the Administration Component of AQT.

Window usage

This is a generic window that can be used for performing a number of different functions. Examples:

• drop tables
• rename tables
• set table comments
• set column comments
• analyse / runstats against tables

Below is the example of the window for Drop Tables.

Object List

When you start this window you will be shown a list of the objects (eg. tables) within your schema.

If you are displaying favorites in the Database Explorer, AQT will either show the favorite objects, or the objects in your schema, depending on the function being performed.

Selecting Items

• To select an object to be processed (for instance, to drop a table), click the checkbox on the left.
• In most cases, the object you had selected in the Database Explorer will be selected in this window.
• If you are renaming a table or entering table / column comments, typing the text will automatically select the object.
• To select all objects, Select > All (or Ctrl+A)
• To select no objects, Select > None (or Ctrl+N)

Skeleton SQL

The SQL that AQT will use to perform the action on the objects is given in Script > View / edit skeleton SQL (or Ctrl+Q). This skeleton SQL is applied against each object you have selected in the grid.

As an example, the skeleton SQL used for dropping tables is drop table <$1:*>.<table:*>. The full syntax of skeleton SQL is not given here, however in the SQL above:

• <$1> is your schema name
• <table> is the name of the item in the Table column in the grid
• :* is a function that is applied to these values. This function will enclose the name in quotes if that is required by your database type. This is useful if the name contains a blank.

If necessary, you can amend this skeleton SQL by changing it in the Skeleton SQL window. Any changes you make will apply only to the current window. The next time you activate this window, the skeleton SQL will revert back to the default value. If you want to make a permanent change to the skeleton SQL, use the Administration Configuration window.

Preview SQL

Displays the SQL that AQT will use to run to perform the action on the selected objects.

Run

Runs the SQL for performing the action on the selected objects. If this involves running more than one SQL statement, you will be shown the Run Multiple Statements window.

AQT keeps track of whether each SQL statement has been run successfully. If so, the row is de-checked. Any rows that fail to be processed will remain checked for you to correct and rerun. In Drop and Rename modes, the rows are not removed or renamed - if you want to see what effect your changes have had, click on Refresh to refresh the data in the display.

You can also run the SQL with F5.

Refresh

Clicking on Refresh will refresh the Object List. You might do this, for instance, after you have renamed or dropped some objects and wish to see the new list of objects.