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 |