16.20 - Generating Multiple Reports From a Single Query - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
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.
  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 .
  5. 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.
  6. To obtain the results of the query, go to the directory where you saved the import file and open the .log file.