Column name
|
Data type
|
Description
|
DATA_TYPE
|
SMALLINT
|
Identification number for data type. |
TYPE_NAME
|
CHAR(30)
|
Name of data type. |
COLUMN_SIZE
|
INTEGER
|
Length of data type name. |
LITERAL_PREFIX
|
CHAR(30)
|
Optional prefix for a literal of this type. |
LITERAL_SUFFIX
|
CHAR(30)
|
Optional suffix for a literal of this type. |
CREATE_PARAMS
|
CHAR(30)
|
A description of how to specify length attributes for the data type. |
NULLABLE
|
SMALLINT
|
One of:
1 = A not null constraint can be used with this type in a domain or column definition
0 = A not null constraint can not be used with this type in a domain or column definition. |
CASE_SENSITIVE
|
SMALLINT
|
One of:
1 = The data type name is case sensitive
0 = The data type name is not case sensitive. |
SEARCHABLE
|
SMALLINT
|
One of:
3 = The data type can be used with any comparison operator
2 = The data type can be used with any comparison operator except like
1 = The data type can only be used with the LIKE operator
0 = The data type can not be used with any comparison operator. |
UNSIGNED_ATTRIBUTE
|
SMALLINT
|
One of:
1 = The data type is unsigned
0 = The data type is signed
The value is null if the data type is non-numeric. |
FIXED_PREC_SCALE
|
SMALLINT
|
One of:
1 = The data type has a determined precision and scale
0 = The data type does not have a determined precision and scale. |
AUTO_UNIQUE_VALUE
|
SMALLINT
|
One of:
1 = The data type will generate unique values
0 = The data type will not generate unique values. |
LOCAL_TYPE_NAME
|
CHAR(30)
|
Local name for data type. |
MINIMUM_SCALE
|
SMALLINT
|
Minimum value for scale for a numeric data type. |
MAXIMUM_SCALE
|
SMALLINT
|
Maximum value for scale for a numeric data type. |
SQL_DATA_TYPE
|
SMALLINT
|
A numeric value representing the data type. |
SQL_DATETIME_SUB
|
SMALLINT
|
Sub type for an interval data type. |
NUM_PREC_RADIX
|
SMALLINT
|
Radix for numeric data type. |
INTERVAL_PRECISION
|
SMALLINT
|
Precision for an interval data type. |
PRECISION
|
INTEGER
|
Precision for data type. |
INTERNAL_LEN_DIFF
|
SMALLINT
|
Internal length difference. |
INTERNAL_TYPENAME
|
CHAR(30)
|
Internal type name. |
INTERNAL_VERSION
|
SMALLINT
|
Internal version number. |
INTERNAL_TYPEORDER
|
SMALLINT
|
Internal type ordering number. |
