15.10 - Example: HELP COLUMN On Multiple table_name.* Expressions - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)
Last Update
2018-06-05

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)