17.00 - UDTs - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K
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