15.10 - Example: HELP COLUMN On Non-Column Expressions Only - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
SQL_DDL_15_10.ditamap
dita:ditavalPath
ft:empty

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)