|
Column Name
|
Type
|
Len
|
Description
|
|
TABLE_QUALIFIER
|
WVARCHAR
|
128
|
Name of database in which the table is created. The default name is SCHEMA.
|
|
TABLE_OWNER
|
WVARCHAR
|
128
|
The owner of the table.
|
|
TABLE_NAME
|
WVARCHAR not NULL
|
128
|
Name of the table
|
|
COLUMN_NAME
|
WVARCHAR
|
128
|
Name of the column of the specified table.
|
|
DATA_TYPE
|
SMALLINT not NULL
|
|
Data type of this column. See Table 118 for the number corresponding to the supported types.
|
|
TYPE_NAME
|
WVARCHAR not NULL
|
254
|
Identifies the column type. Used to display to end user. The table owner uses information from the data_type column. See Table 118 for the name.
|
|
OA_LENGTH
|
INTEGER
|
|
Maximum length for character data types. Leave null for other types.
CHAR and VARCHAR - maximum length of the string
NUMERIC - precision + 2
INTEGER=4, SMALLINT=2, DOUBLE=8, REAL=4,FLOAT=8
DATE=6, TIME=6, TIMESTAMP=16
|
|
OA_PRECISION
|
INTEGER
|
|
Number of digits of mantissa precision.
NUMERIC - Number of digits
CHAR and VARCHAR - set to same as OA_LENGTH
INTEGER=10, SMALLINT=5, DOUBLE=15, REAL=7,FLOAT=15
DATE=10, TIME=8, TIMESTAMP=19
|
|
DECIMAL_DIGITS
|
SMALLINT
|
|
Total # of significant digits to the right of the decimal point. Only required for NUMERIC types.
|
|
OA_RADIX
|
SMALLINT
|
|
Reserved for future use. Set to null.
|
|
OA_NULLABLE
|
SMALLINT
not NULL
|
|
Whether the column can be null:
XO_NO_NULLS (0) – No nulls allowed
XO_NULLABLE (1) – Can be null
XO_NULLABLE_UNKNOWN (2) – Nullable unknown
|
|
REMARKS
|
WVARCHAR
|
254
|
The description of the column
|
|
OA_COLUMN_DEF
|
WVARCHAR
|
|
The default value of the column. The value in this column should be interpreted as a string if it is enclosed in quotation marks.
If the default value was specified as NULL, then this column is the word NULL, not enclosed in quotation marks. If the default value cannot be represented without truncation, then this column contains TRUNCATED, with no enclosing single quotation marks. If no default value was specified, then this column is NULL.
The value of COLUMN_DEF can be used in generating a new column definition, except when it contains the value TRUNCATED.
|
|
OA_SQLDATA_TYPE
|
SMALLINT not NULL
|
|
Returns the same value as returned by the DATA_TYPE column. For DATE, TIME, and TIMESTAMP columns, OA_SQLDATA_TYPE is mapped to XO_TYPE_DATE.
|
|
OA_SQL_DATETIME_SUB
|
SMALLINT
|
|
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_CHAR_OCTET_ LENGTH
|
INTEGER
|
|
The maximum length in bytes of a character or binary data type column. For all other data types, this column returns a NULL.
|
|
OA_ORDINAL_ POSITION
|
INTEGER not NULL
|
|
The ordinal position of the column in the table. The first column in the table is column number 1.
|
|
OA_IS_NULLABLE
|
WVARCHAR
|
|
NO if the column does not include NULLs.
YES if the column could include NULLs.
This column returns a zero-length string if the nullability is unknown.
The value returned for this column is different from the value returned for the NULLABLE column. (See the description of the NULLABLE column.)
|
|
OA_SCOPE
|
SMALLINT NULL
|
|
Special column. This column can be accessed using SQLSpecialColumns.
|
|
PSEUDO_COLUMN
|
SMALLINT NULL
|
|
Special column. This column can be accessed using SQLSpecialColumns.
|
|
OA_COLUMNTYPE
|
SMALLINT NULL
|
|
Special column. This column can be accessed using SQLSpecialColumns.
|