|
Column Name
|
Type
|
Len
|
Description
|
|
TYPE_NAME
|
WVARCHAR
not NULL
|
128
|
Data source-dependent type name
|
|
DATA_TYPE
|
SMALLINT not NULL
|
|
ODBC SQL data type
|
|
OA_PRECISION
|
INTEGER
|
|
The maximum precision of the data type on the data source. NULL is returned for data types where precision is not applicable.
|
|
LITERAL_PREFIX
|
VARCHAR
|
128
|
Character or characters used to prefix a literal.
|
|
LITERAL_SUFFIX
|
VARCHAR
|
128
|
Character or characters used to suffix a literal.
|
|
CREATE_PARAMS
|
VARCHAR
|
128
|
Parameters for data type definition.
|
|
OA_NULLABLE
|
SMALLINT not NULL
|
|
Whether the data type can be null:
XO_NO_NULLS (0) – No nulls allowed
XO_NULLABLE (1) – Can be null
XO_NULLABLE_UNKNOWN (2) – Nullable unknown
|
|
CASE_SENSITIVE
|
SMALLINT not NULL
|
|
Whether the data type is case sensitive in collation and comparison.
TRUE if the data type is a character data type and it is case sensitive.
FALSE if the data type is not a character data type or is not case sensitive.
|
|
OA_SEARCHABLE
|
SMALLINT not NULL
|
|
How the data type is used in a WHERE clause.
|
|
UNSIGNED_ATTRIB
|
SMALLINT
|
|
Whether the data type is unsigned. OpenAccess SDK does not support unsigned data types.
|
|
OA_MONEY
|
SMALLINT not NULL
|
|
Whether the data type is a money data type.
|
|
AUTO_INCREMENT
|
SMALLINT
|
|
Whether the data type is autoincrementing.
|
|
LOCAL_TYPE_NAME
|
WVARCHAR
|
128
|
Localized version of the database dependent data type name.
|
|
MINIMUM_SCALE
|
SMALLINT
|
|
Minimum scale of the data type.
|
|
MAXIMUM_SCALE
|
SMALLINT
|
|
Maximum scale of the data type.
|
|
OA_SQL_DATA_TYPE
|
smallint not NULL
|
16
|
The value of the SQL data type as it appears in the SQL_DESC_TYPE field of the descriptor. This column is the same as the DATA_TYPE column except for the datetime data types DATE, TIME, TIMESTAMP.
For datetime data types, the OA_SQL_DATA_TYPE field in the result set will be SQL_DATETIME (9), and the OA_SQL_DATETIME_SUB field will return the subcode for the specific datetime data type (SQL_CODE_DATE, SQL_CODE_TIME or SQL_CODE_TIMESTAMP).
|
|
OA_SQL_DATETIME_SUB
|
smallint
|
17
|
The subtype code for datetime data types. For other data types, this column returns a NULL.
SQL_CODE_DATE=1
SQL_CODE_TIME=2
SQL_CODE_TIMESTAMP=3
|
|
OA_NUM_PREC_ RADIX
|
integer
|
18
|
If the data type is an approximate numeric type, this column contains the value 2 to indicate that COLUMN_SIZE specifies a number of bits.
For exact numeric types, this column contains the value 10 to indicate that COLUMN_SIZE specifies a number of decimal digits. Otherwise, this column is NULL.
|
|
OA_INTERVAL_ PRECISION
|
smallint
|
19
|
Return NULL. The interval data type is not supported.
|