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