Listing All Tables or Views In a Database - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

SQL Assistant
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

1 Do one of the following:

  • Select Tools > List Tables.
  • On the toolbar click .
  • 2 In the Database Name field, type the name of the database (or owner, if using Oracle) containing the tables.

    Enter the following wildcard characters in this field:

    Note: 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 "_%".

    Note: This field does not apply to Microsoft Access databases.

    3 At least one of the following must be selected:

  • Show Tables – lists the tables in the selected database.
  • Show Views – lists the views in the selected database.
  • The resulting list of tables, views and/or system tables appears in an Answerset window. This window does not automatically close when new queries are submitted.