17.10 - UDTs - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)
The user-defined type (UDT) objects in the database contain:
  • DBC.UDTInfo - one entry per UDT
    • Type name
    • Type kind (Distinct or Structured)
    • Whether the type is instantiable
    • Default transform group (name)
    • Ordering form (full ordering or equals only - distinct and structured types are always full)
    • Ordering category (map or relative - distinct and structured types are always map)
    • Ordering routine ID
    • Cast count
  • DBC.UDTCast - one entry per cast for a UDT
    • Whether cast is implicit assignment
    • Cast routine ID
  • DBC.UDFInfo - one entry for the auto-generated default constructor of the UDT; entries are the same as for a regular (C/C++) UDF
  • DBC.UDTTransform - one entry for the UDT transform group and routine identifiers
    • Default transform group name
    • ToSQL routine ID
    • FromSQL routine ID