16.20 - UDTs - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

The user-defined type (UDT) objects in the Teradata Database platform 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