EXA_SQL_TYPES

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: 0 - Cannot be searched 1 - Can only be searched with `WHERE` .. `LIKE` 2 - Cannot be searched with `WHERE` .. `LIKE` 3 - Can be searched with any `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