SQLUDTS

The SQLUDTS view contains one row for every distinct type.

The following table describes the columns in the view:

Table 1. 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™ 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.math.BigDecimal DECFLOAT 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 java.sql.SQLXML XML
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 1111 DECFLOAT 1 CHARACTER or GRAPHIC -15 NCHAR –2 CHARACTER FOR BIT DATA or BINARY 12 VARCHAR or VARGRAPHIC -9 NVARCHAR –3 VARCHAR FOR BIT DATA or VARBINARY 2005 CLOB or DBCLOB 2011 NCLOB 2004 BLOB 91 DATE 92 TIME 93 TIMESTAMP 70 DATALINK 1111 ROWID 2009 XML
REMARKS	VARGRAPHIC(2000) CCSID 1200 Nullable	A character string supplied with the COMMENT statement. Contains the null value if there is no comment.