17.00 - UDTInfoV - 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

Category: Schema

Database: DBC

View Column Data Type Format Comment
TypeId BYTE(6) NOT NULL X(12) Returns the identifier for the UDT
DatabaseId BYTE(4) NOT NULL X(8) Returns the identifier of the database in which the UDT is defined
TypeName VARCHAR(128) UNICODE UPPERCASE NOT NULL X(128) Returns the type designator. The name corresponds to the column TVMName in the DBC.TVM table
TypeKind CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns the classification of the UDT
INSTANTIABLE CHAR(1) LATIN UPPERCASE NOT NULL X(1) An indication of whether the UDT is instantiable
FINAL CHAR(1) LATIN UPPERCASE NOT NULL X(1) An indication of whether the UDT is final
Encryption CHAR(1) LATIN UPPERCASE NOT NULL X(1) An indication of whether encryption is supported for this UDT
Compression CHAR(1) LATIN UPPERCASE NOT NULL X(1) An indication of whether compression is supported for this UDT
OperatorAll CHAR(1) LATIN UPPERCASE NOT NULL X(1) An indication of whether operators specific to predefined data types are supported for a distinct types base data type
DefaultTransformGroup VARCHAR(128) UNICODE UPPERCASE X(128) Returns the name of the Transform group that is selected automatically for importing or exporting and is used in the absence of a specific choice made by the user
OrderingForm CHAR(1) LATIN UPPERCASE NOT NULL X(1) An indication of the level of comparison and sorting for the UDT.
OrderingCategory CHAR(1) LATIN UPPERCASE X(1) An indication of the manner of comparison.
OrderingRoutineId BYTE(6) X(12) Specifies the identifier of the user-defined ordering routine
CastCount BYTEINT NOT NULL -(3)9 Returns the number of user-defined casts involving this UDT
ExtFileReference VARCHAR(1000) UNICODE CASESPECIFIC X(1000) An encoded string that contains the external name or path of each file component that together provide core DBS integration methods for the UDT
DefaultNull CHAR(1) LATIN UPPERCASE X(1) Indicates whether the DEFAULT NULL clause was specified when the ARRAY data type was created
ArrayNumDimensions BYTEINT -(3)9 Contains a numeric value that indicates the number of dimensions for an ARRAY type
ArrayScope VARCHAR(3200) LATIN UPPERCASE X(3200) Contains a string of the format '[n:m]...' which describes the lower and upper bounds values for each dimension of the ARRAY type