16.20 - Example: HELP COLUMN On Non-Column Expressions Only - 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
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

The following request executes HELP COLUMN on 3 expressions, but no actual columns. Note that report does not include column names, but instead lists the data types, nullability, and output format.

     HELP COLUMN 1+10, 10.1+1, 'asdf'||'asd1';
     *** Help information returned. 3 rows.
     *** Total elapsed time was 1 second.
     Column Name                 Type Nullable Format
     --------------------------- ---- -------- -------------------------
                                 I    Y        -(10)9
                                 D    Y        ---------------.9
                                 CV   Y        X(8)