16.20 - Example: HELP COLUMN On Multiple table_name.* Expressions - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

The following request executes HELP COLUMN on all columns of two separate tables.

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