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

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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)