You can generate multiple reports from a single query using SQL Assistant’s import feature. This is often useful for DBAs. The following procedure shows the DDL for a list of tables.
- Create an import file (typically a .txt file) that contains a list of tables, one table name per line.
- Select .
-
Enter the following into the Query window:
SHOW TABLE ?
-
Click
.
-
In the file selection dialog box, select the file you saved.
The status bar at the bottom of the Query window shows row numbers as they are loaded.
- To obtain the results of the query, go to the directory where you saved the import file and open the .log file.