SQLUDTS

The SQLUDTS view contains one row for every distinct type. The following table describes the columns in the view:

Table 153. SQLUDTS 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.
java.math.BigInteger
BIGINT
java.lang.Integer
INTEGER
java.lang.Short
SMALLINT
java.math.BigDecimal
DECIMAL
java.sql.BigDecimal
NUMERIC
java.lang.Double
DOUBLE PRECISION
java.lang.Float
REAL
java.lang.String
CHARACTER
byte[]
CHARACTER FOR BIT DATA
java.lang.String
VARCHAR
byte[]
VARCHAR FOR BIT DATA
java.sql.Clob
CLOB
java.lang.String
GRAPHIC
java.lang.String
VARGRAPHIC
java.sql.Clob
DBCLOB
byte[]
BINARY
byte[]
VARBINARY
java.sql.Blob
BLOB
java.sql.Date
DATE
java.sql.Time
TIME
java.sql.Timestamp
TIMESTAMP
java.net.URL
DATALINK
byte[]
ROWID
DATA_TYPE SMALLINT Reserved. Contains 2001.
BASE_TYPE SMALLINT The source data type of the user-defined data type:
-5
BIGINT
4
INTEGER
5
SMALLINT
3
DECIMAL
2
NUMERIC
8
DOUBLE PRECISION
7
REAL
1
CHARACTER
-2
CHARACTER FOR BIT DATA
12
VARCHAR
-3
VARCHAR FOR BIT DATA
2005
CLOB
1
GRAPHIC
12
VARGRAPHIC
1111
DBCLOB
-2
BINARY
-3
VARBINARY
2004
BLOB
91
DATE
92
TIME
93
TIMESTAMP
70
DATALINK
1111
ROWID
REMARKS VARCHAR(2000)
Nullable
A character string supplied with the COMMENT statement.

Contains the null value if there is no comment.