Generating Multiple Reports From a Single Query
You can generate multiple reports from a single query using SQL Assistant’s import feature. This is often useful for DBAs.
1 Create an import file (typically a .txt file) that contains a list of tables, one table name per line.
2 Select File > Import Data.
3 Enter the following into the Query Window:
SHOW TABLE ?
4 Click .
This displays a file selection dialog box.
5 Select the file you saved.
The status bar at the bottom of the Query window shows row numbers as they are loaded.
6 To obtain the results of the query, go to the directory in which you saved the import file and open the .log file.