HELP TYPE Examples | Teradata Vantage - 17.00 - Example: HELP TYPE with No Options Specified - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

The following example shows the standard report returned by HELP TYPE when you do not specify any options.

     HELP TYPE euro;
                    Name euro
            Internal Type UD
            External Type D
               Max Length         8
     Decimal Total Digits     ?
Decimal Fractional Digits     ?
             Contains LOB N
                 Ordering F
        Ordering Category M
         Ordering Routine SYSUDTLIB.euro_to_decimal
                     Cast Y
                Transform Y
                   Method Y
                Char Type  1
              Array (Y/N) N
               Dimensions             ?
             Element Type ?
                 UDT Name ?
              Array Scope ?