17.05 - Example: HELP COLUMN On a Mixture of Non-Column Expressions and table_name .* Expressions - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

The following request executes HELP COLUMN on an integer expression and all columns of the d table. Note that the report does not report a column name for the integer expression.

     HELP COLUMN 1+1, d.*;
      *** Help information returned. 5 rows.
      *** Total elapsed time was 1 second.
     Column Name                Type Nullable Format
     -------------------------- ---- -------- ----------------------
                                I    Y        -(10)9
     transaction_header_key     I    Y        -(10)9
     vendor_key                 I    Y        -(10)9
     item_key                   I    Y        -(10)9
     stuff                      CF   Y        X(300)