|
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.
|