The USER_DEFINED_TYPES view contains one row for each distinct type.
The following table describes the columns in the view1:
| Column Name | Data Type | Description |
|---|---|---|
| USER_DEFINED_TYPE_CATALOG | VARCHAR(128) | Relational database name |
| USER_DEFINED_TYPE_SCHEMA | VARCHAR(128) | Schema name of the distinct type |
| USER_DEFINED_TYPE_NAME | VARCHAR(128) | Name of the user that created the distinct type. |
| USER_DEFINED_TYPE_CATEGORY | VARCHAR(128) | Indicates the type of user-defined type. Contains 'DISTINCT'. |
| IS_INSTANTIABLE | VARCHAR(3) | Reserved. Contains 'YES'. |
| IS_FINAL | VARCHAR(3) | Reserved. Contains 'YES'. |
| ORDERING_FORM | VARCHAR(4) | Indicates what kind of predicates
are allowed when this distinct type is a comparand:
|
| ORDERING_CATEGORY | VARCHAR(8) | Reserved. Contains 'MAP'. |
| ORDERING_ROUTINE_CATALOG | VARCHAR(128) Nullable |
Relational database name Contains the null value if the ORDERING_FORM is 'NONE'. |
| ORDERING_ROUTINE_SCHEMA | VARCHAR(128) Nullable |
Reserved. Contains 'SYSIBM'. Contains the null value if the ORDERING_FORM is 'NONE'. |
| ORDERING_ROUTINE_NAME | VARCHAR(128) Nullable |
Reserved. Contains a data type name. Contains the null value if the ORDERING_FORM is 'NONE'. |
| REFERENCE_TYPE | VARCHAR(16) Nullable |
Reserved. Contains the null value. |
| DATA_TYPE | VARCHAR(128) Nullable |
Source data type of the distinct
type:
|
| CHARACTER_MAXIMUM_LENGTH | INTEGER Nullable |
Maximum length of the
distinct type for binary, character, and graphic string and XML data
types. Contains the null value if the distinct type is not a string. ![]() |
| CHARACTER_OCTET_LENGTH | INTEGER Nullable |
Number of bytes of the
distinct type for binary, character, and graphic string and XML data
types. Contains the null value if the distinct type is not a string. ![]() |
| CHARACTER_SET_CATALOG | VARCHAR(128) Nullable |
Relational database name of the distinct
type. Contains the null value if the distinct type is not a string. |
| CHARACTER_SET_SCHEMA | VARCHAR(128) Nullable |
The schema name of the character
set of the distinct type. Contains 'SYSIBM'. Contains the null value if the distinct type is not a string. |
| CHARACTER_SET_NAME | VARCHAR(128) Nullable |
The character set name of the distinct
type. Contains the null value if the distinct type is not a string. |
| COLLATION_CATALOG | VARCHAR(128) Nullable |
Relational database name of the distinct
type. Contains the null value if the distinct type is not a string. |
| COLLATION_SCHEMA | VARCHAR(128) Nullable |
The schema of the collation of the
distinct type. SYSIBM is returned. Contains the null value if the distinct type is not a string. |
| COLLATION_NAME | VARCHAR(128) Nullable |
The collation name of the distinct
type. IBMBINARY is returned. Contains the null value if the distinct type is not a string. |
| NUMERIC_PRECISION | INTEGER Nullable |
The precision of the distinct type.
Note: This column supplies the precision of all numeric data types,
including single-and double-precision floating point and decimal floating-point.
The NUMERIC_PRECISION_RADIX column indicates if the value in this
column is in binary or decimal digits.
Contains the null value if the distinct type is not numeric. |
| NUMERIC_PRECISION_RADIX | INTEGER Nullable |
Indicates if the precision specified
in column NUMERIC_PRECISION is specified as a number of binary or
decimal digits:
Contains the null value if the distinct type is not numeric. |
| NUMERIC_SCALE | SMALLINT Nullable |
Scale of numeric distinct type. Contains the null value if the distinct type is not decimal, numeric, or binary. |
| DATETIME_PRECISION | INTEGER Nullable |
The fractional part of a date, time,
or timestamp distinct type.
Contains the null value if the distinct type is not date, time, or timestamp. |
| INTERVAL_TYPE | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| INTERVAL_PRECISION | INTEGER Nullable |
Reserved. Contains the null value. |
| SOURCE_DTD_IDENTIFIER | VARCHAR(128) Nullable |
A unique internal identifier for
the source data type. Contains the null value if the distinct type is not sourced on another distinct type. |
| REF_DTD_IDENTIFIER | VARCHAR(256) Nullable |
Reserved. Contains the null value. |