15.10 - Example: HELP TYPE for a Distinct UDT Type - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Teradata Database
Release Number
December 2015
Content Type
Programming Reference
Publication ID
English (United States)

This example shows the standard report returned by HELP TYPE for a distinct UDT type.

Suppose you create the following ARRAY type.

     CREATE TYPE mydistinct AS

This type returns the following report to a HELP TYPE request.

     HELP TYPE mydistinct;
                    Name mydistinct
            Internal Type UD
            External Type I
               Max Length              4
     Decimal Total Digits     ?
Decimal Fractional Digits     ?
             Contains LOB N
                 Ordering F
        Ordering Category M
         Ordering Routine SYSTEM
                     Cast Y
                Transform Y
                   Method N
                Char Type  ?
              Array (Y/N) N
               Dimensions             ?
             Element Type ?
                 UDT Name ?
              Array Scope ?