SYSCAT.DATATYPES catalog view
Each row represents a built-in or user-defined data type.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
TYPESCHEMA | VARCHAR (128) | Schema name of the data type if TYPEMODULEID is null; otherwise schema name of the module to which the data type belongs. | |
TYPEMODULENAME | VARCHAR (128) | Y | Unqualified name of the module to which the user-defined type belongs. The null value if not a module user-defined type. |
TYPENAME | VARCHAR (128) | Unqualified name of the data type. | |
OWNER | VARCHAR (128) | Authorization ID of the owner of the type. | |
OWNERTYPE | CHAR (1) |
|
|
SOURCESCHEMA | VARCHAR (128) | Y | For distinct types or array types, the schema name of the source data type. For user-defined structured types, the schema name of the built-in type of the reference representation type. Null for other data types. |
SOURCEMODULENAME | VARCHAR (128) | Y | Unqualified name of the module to which the source data type belongs. The null value if not a module source data type. |
SOURCENAME | VARCHAR (128) | Y | For distinct types or array types, the unqualified name of the source data type. For user-defined structured types, the unqualified built-in type name of the reference representation type. Null for other data types. |
METATYPE | CHAR (1) |
|
|
TYPERULES | CHAR(1) | Indicates the type rules for the user-defined
type.
|
|
TYPEID | SMALLINT | Identifier for the data type. | |
TYPEMODULEID | INTEGER | Y | Identifier for the module to which the user-defined type belongs. The null value if not a module user-defined type. |
SOURCETYPEID | SMALLINT | Y | Identifier for the source type (the null value for built-in types). For user-defined structured types, this is the identifier of the reference representation type. |
SOURCEMODULEID | INTEGER | Y | Identifier for the module to which the source data type belongs. The null value if not a module source data type. |
PUBLISHED | CHAR (1) | Indicates whether the module user-defined type can be referenced
outside its module.
|
|
LENGTH | INTEGER | Maximum length of the type. 0 for built-in parameterized types (for example, DECIMAL and VARCHAR ). For user-defined structured types, this is the length of the reference representation type. | |
SCALE | SMALLINT | Scale for distinct types or reference representation types based on the built-in DECIMAL type; the number of digits of fractional seconds for distinct types based on the built-in TIMESTAMP type; 6 for the built-in TIMESTAMP type; 0 for all other types (including DECIMAL itself). | |
TYPESTRINGUNITS | VARCHAR (11) | Y | In a Unicode database, the string units that apply to a character string or graphic string data type. Otherwise, the null value. |
STRINGUNITSLENGTH | INTEGER | Y | In a Unicode database, the declared number of string units for a character string or graphic string data type. Otherwise, the null value. |
CODEPAGE | SMALLINT | Database code page for string types, distinct types based on string types, or reference representation types; 0 otherwise. | |
COLLATIONSCHEMA | VARCHAR (128) | Y | For string types, the schema name of the collation for the data type; the null value otherwise. |
COLLATIONNAME | VARCHAR (128) | Y | For string types, the unqualified name of the collation for the data type; the null value otherwise. |
ARRAY_LENGTH | INTEGER | Y | Maximum cardinality of the array. The null value if METATYPE is not 'A'. |
ARRAYINDEXTYPESCHEMA | VARCHAR (128) | Y | Schema of the data type of the array index. The null value if METATYPE is not 'L'. |
ARRAYINDEXTYPENAME | VARCHAR (128) | Y | Name of the data type of the array index. The null value if METATYPE is not 'L'. |
ARRAYINDEXTYPEID | SMALLINT | Y | Identifier for the array index type. The null value if METATYPE is not 'L'. |
ARRAYINDEXTYPELENGTH | INTEGER | Y | Maximum length of the array index data type. The null value if METATYPE is not 'L'. |
ARRAYINDEXTYPE_STRINGUNITS | VARCHAR (11) | Y | In a Unicode database, the string units that apply to a character string array index data type. Otherwise, the null value. |
ARRAYINDEXTYPE_STRINGUNITSLENGTH | INTEGER | Y | In a Unicode database, the declared number of string units for a character string array index data type. Otherwise, the null value. |
CREATE_TIME | TIMESTAMP | Creation time of the data type. | |
VALID | CHAR (1) |
|
|
ATTRCOUNT | SMALLINT | Number of attributes in the data type. | |
INSTANTIABLE | CHAR (1) |
|
|
WITH_FUNC_ACCESS | CHAR (1) |
|
|
FINAL | CHAR (1) |
|
|
INLINE_LENGTH | INTEGER | Maximum length of a structured type that can be kept with a base table row; 0 otherwise. | |
NATURAL_INLINE_LENGTH | INTEGER | Y | System-generated natural inline length of a structured type instance. The null value if this type is not a structured type. |
JARSCHEMA | VARCHAR (128) | Y | Schema name of the JAR_ID that identifies the Jar file containing the Java™ class that implements the SQL type. The null value if the EXTERNAL NAME clause is not specified. |
JAR_ID | VARCHAR (128) | Y | Identifier for the Jar file that contains the Java class that implements the SQL type. The null value if the EXTERNAL NAME clause is not specified. |
CLASS | VARCHAR (384) | Y | Java class that implements the SQL type. The null value if the EXTERNAL NAME clause is not specified. |
SQLJ_REPRESENTATION | CHAR (1) | Y | SQLJ "representation_spec" of the Java class
that implements the SQL type. The null value if the EXTERNAL NAME
... LANGUAGE JAVA REPRESENTATION SPEC clause is not specified.
|
ALTER_TIME | TIMESTAMP | Time at which the data type was last altered. | |
DEFINER1 | VARCHAR (128) | Authorization ID of the owner of the type. | |
NULLS | CHAR (1) | Nullability attribute for the type.
|
|
FUNC_PATH | CLOB (2K) | Y | SQL path in effect when the type was created. The null value if no data type check constraint exists. |
CONSTRAINT_TEXT | CLOB (64K) | Y | Predicate text which constrains the values allowed for the data type. The null value if no data type check constraint exists. |
LAST_REGEN_TIME | TIMESTAMP | Time at which the data type check constraint was last regenerated. The same value as CREATE_TIME if no data type check constraint exists. | |
ENVSTRINGUNITS | VARCHAR (11) | Default string units when the object was created. | |
REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |
Note:
|