This system table describes the SQL data types of Exasol. All users have access to the table.
| Column Name | Description |
|---|---|
| TYPE_NAME | Name according to SQL standard |
| TYPE_ID | ID of the data type |
| PRECISION | The precision in relation to numeric values, the (maximum) length in bytes in relation to strings and other types |
| LITERAL_PREFIX | Prefix, with which a literal of this type must be initiated |
| LITERAL_SUFFIX | Suffix, with which a literal of this type must be terminated |
| CREATE_PARAMS | Information on which information is necessary in order to create a column of this type |
| IS_NULLABLE | States whether NULL values are allowed (TRUE or FALSE). |
| CASE_SENSITIVE | States whether case sensitivity is relevant to the type |
| SEARCHABLE |
States how the type can be used in a WHERE clause:
|
| UNSIGNED_ATTRIBUTE | States whether the type is unsigned |
| FIXED_PREC_SCALE | States whether the type has fixed representation |
| AUTO_INCREMENT | States whether it is an automatically incremented type |
| LOCAL_TYPE_NAME | Local type name |
| MINIMUM_SCALE | Minimum number of digits after the decimal point |
| MAXIMUM_SCALE | Maximum number of digits after the decimal point |
| SQL_DATA_TYPE | Reserved |
| SQL_DATETIME_SUB | Reserved |
| NUM_PREC_RADIX | Number base for details of the precision |
| INTERVAL_PRECISION | Reserved |
