solidDB Help : solidDB reference : SQL: Database system tables and system views : System tables : SYS_TYPES
  
SYS_TYPES
The columns in the SYS_TYPES system table are described in the following table:
 
Column name
Data type
Description
TYPE_NAME
WVARCHAR
The name of the data type.
DATA_TYPE
SMALLINT
ODBC, data type number.
PRECISION
INTEGER
ODBC, the precision of the data type.
LITERAL_PREFIX
WVARCHAR
ODBC, possible prefix for literal values.
LITERAL_SUFFIX
WVARCHAR
ODBC, possible suffix for literal values.
CREATE_PARAMS
WVARCHAR
ODBC, the parameters needed to create a column of the data type.
NULLABLE
SMALLINT
ODBC, can the data type contain NULL values.
CASE_SENSITIVE
SMALLINT
ODBC, is the data type case sensitive.
SEARCHABLE
SMALLINT
ODBC, the supported search operations.
UNSIGNED_ATTRIBUTE
SMALLINT
ODBC, is the data type unsigned.
MONEY
SMALLINT
ODBC, whether the data is a money data type.
AUTO_INCREMENT
SMALLINT
ODBC, whether the data type is autoincrementing.
LOCAL_TYPE_NAME
WVARCHAR
ODBC, has the data type another implementation defined name.
MINIMUM_SCALE
SMALLINT
ODBC, the minimum scale of the data type.
MAXIMUM_SCALE
SMALLINT
ODBC, the maximum scale of the data type.
Go up to
System tables