15.10 - Example: HELP TYPE for a UDT with the ATTRIBUTE Option - 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 examples show the standard report returned by HELP TYPE when you specify the ATTRIBUTE option.

The first example shows how the name for the structured UDT named address is returned with full qualification.

     HELP TYPE address ATTRIBUTE;
            Attribute Name street
                       Type CV
                 Max Length             20
       Decimal Total Digits     ?
  Decimal Fractional Digits      ?
                  Range Low ?
                 Range High ?
                  Char Type  1
                   UDT Name SYSUDTLIB.UDTName(assuming street is a UDT)
             Attribute Name zip
                       Type CF
                 Max Length 5
       Decimal Total Digits     ?
  Decimal Fractional Digits      ?
                  Range Low ?
                 Range High ?
                  Char Type  1
                   UDT Name ?

The second example shows a report returned when the specified structured type insv_structured_smallint has multiple attributes, two of which are themselves structured UDTs.

     HELP TYPE  insv_structured_smallint ATTRIBUTE;
             Attribute Name  Attribute1
                        Type  I2
                  Max Length               2
        Decimal Total Digits     ?
   Decimal Fractional Digits      ?
                   Range Low ?
                  Range High ?
                   Char Type  ?
                    UDT Name  ?
              Attribute Name  Attribute2
                        Type  UD
                  Max Length              4
        Decimal Total Digits     ?
   Decimal Fractional Digits      ?
                   Range Low ?
                  Range High ?
                   Char Type   ?
                     UDT Name  SYSUDTLIB.UDTINT
                Attribute Name  Attribute3
                        Type  UD
                  Max Length             50
        Decimal Total Digits     ?
   Decimal Fractional Digits      ?
                   Range Low ?
                  Range High ?
                   Char Type  ?
                    UDT Name SYSUDTLIB.UDTBLOB10