17.00 - Example: HELP TYPE for a UDT with the ATTRIBUTE Option - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

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