16.20 - Example: HELP DATABASE Output Showing a UDT and a Method - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

The following example shows that there is a UDT named euro and a method named euro_To_US in the SYSUDTLIB database.

     HELP DATABASE SYSUDTLIB;
     Table/View/Macro name euro
                      Kind U
                   Comment ?
                Protection F
              Creator Name USER1
             Commit Option N
           Transaction Log Y
     Table/View/Macro name euro_To_US
                      Kind H
                   Comment ?
                Protection F
              Creator Name USER1
             Commit Option N
           Transaction Log Y