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

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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