The USER_DEFINED_TYPES view contains one row for each distinct
type.
112
The following table describes the columns in the view:
Table 162. USER_DEFINED_TYPES view
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 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 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.
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 | INTEGER
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. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.