Listing All Columns In a Table or View - 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 Columns.
  • On the toolbar click .
  • 2 In Database Name field, type the name of the database (or owner, if using Oracle) containing the table or view.

    This field does not apply to Microsoft Access databases.

    3 In Table or View Name, type the name of the table or view.

    The resulting list of columns appear in an Answerset window. This window does not automatically close when new queries are submitted.