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 |