16.20 - Listing All Tables or Views In a Database - 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
  1. Do one of the following:
    • Click .
    • Select Tools > List Tables.
  2. In Database Name, type the name of the database (or owner, if using Oracle) containing the tables.

    Enter the following wildcard characters in this field:

    Wildcard characters only function when using an ODBC connection.
    • "_" Matches any single character
    • "%" Matches zero or more characters

    If the name is specified as a single percent sign ("%") this has special meaning to some ODBC drivers. It requests a list of all databases on the system, rather than all Tables within all Databases. To display all tables in all databases, it is safer to specify either "%%" or "_%".

    This field does not apply to Microsoft Access databases.
  3. Select one or both options:
    • Show Tables – lists the tables in the selected database.
    • Show Views – lists the views in the selected database.
The resulting list of tables, views, or system tables appears in an Answerset window. This window does not automatically close when new queries are submitted.