Contains a row for every data type, including built-in and user-defined
types.
Table 67. SYSCAT.DATATYPES Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| TYPESCHEMA | CHAR(8) |
| Qualified name of the data type (for built-in types, TYPESCHEMA is SYSIBM). |
| TYPENAME | VARCHAR(18) |
| |
| DEFINER | CHAR(8) |
| Authorization ID under which type was created. |
| SOURCESCHEMA | CHAR(8) | Yes | Qualified name of the source type for distinct types. Qualified name of the builtin type used as the reference type that is used as the representation for references to structured types. Null for other types. |
| SOURCENAME | VARCHAR(18) | Yes | |
| METATYPE | CHAR(1) |
|
|
| TYPEID | SMALLINT |
| The system generated internal identifier of the data type. |
| SOURCETYPEID | SMALLINT | Yes | Internal type ID of source type (null for built-in types). For user-defined structured types, this is the internal type ID of the reference representation type. |
| LENGTH | INTEGER |
| Maximum length of the type. 0 for system predefined parameterized types (for example, DECIMAL and VARCHAR). For user-defined structured types, this indicates the length of the reference representation type. |
| SCALE | SMALLINT |
| Scale for distinct types or reference representation types based on the system predefined DECIMAL type. 0 for all other types (including DECIMAL itself). |
| CODEPAGE | SMALLINT |
| Code page for character and graphic distinct types or reference representation types; 0 otherwise. |
| CREATE_TIME | TIMESTAMP |
| Creation time of the data type. |
| REMARKS | VARCHAR(254) | Yes | User-supplied comment, or null. |