v_sys_udts¶
用户数据类型的信息。
| 列名 | 类型 | 描述 |
|---|---|---|
| TYPE_CAT | VARCHAR(128) | 返回类型所处Catalog名,如果数据源不支持Catalog,返回NULL |
| TYPE_SCHEM | VARCHAR(128) | 类型所处的Schema名称 |
| TYPE_NAME | VARCHAR(128) | 类型名 |
| CLASS_NAME | VARCHAR(128) | 类型所对应的类名 |
| DATA_TYPE | SMALLINT | 该类型的数据源数据类型。One of JAVA_OBJECT, STRUCT, or DISTINCT |
| REMARKS | VARCHAR(128) | 对该类型的说明 |
| BASETYPE | SMALLINT | type code of the source type of a DISTINCT type or the type that implements the user-generated reference type of the SELF_REFERENCING_COLUMN of a structured type as defined in java.sql.Types (null if DATA_TYPE is not DISTINCT or not STRUCT with REFERENCE_GENERATION = USER_DEFINED) |