The SQLUDTS view contains one row for every distinct type. The following table describes the columns in the view:
Column Name | Data Type | Description |
---|---|---|
TYPE_CAT | VARCHAR(128) | Relational database name |
TYPE_SCHEM | VARCHAR(128) | Name of the schema containing the user-defined type. |
TYPE_NAME | VARCHAR(128) | Name of the user-defined type. |
CLASS_NAME | VARCHAR(20) | Java(TM) class name of the user-defined type.
|
DATA_TYPE | SMALLINT | Reserved. Contains 2001. |
BASE_TYPE | SMALLINT | The source data type of the user-defined
data type:
|
REMARKS | VARCHAR(2000)
Nullable |
A character string supplied with the COMMENT
statement.
Contains the null value if there is no comment. |
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.