Column | Data Type | N | Description |
RECORD_NUMBER | integer | n | unique identifier for this record of metadata |
TABLE_CATALOG | identifier | n | table catalog |
TABLE_SCHEMA | identifier | n | table schema |
TABLE_NAME | identifier | n | table name |
COLUMN_NAME | identifier | n | column name |
ORDINAL_POSITION | integer | n | ordinal position inside the containing table. |
COLUMN_DEFAULT | long_alpha | y | default option in character representation. |
IS_NULLABLE | yes_no | n | Y if Null is possible, N if not possible. |
DATA_TYPE_NUMBER | short | n | data type (in integer form) |
DATA_TYPE | enumeration | n | data type (in text form) |
CHARACTER_MAXIMUM_LENGTH | long | n | physical length of data in characters. |
CHARACTER_OCTET_LENGTH | long | n | physical length of data in bytes. |
NUMERIC_PRECISION | long | n | precision of the data. |
NUMERIC_PRECISION_RADIX | short | n | Radix of the precision. Radix is 2 for floating point data and 10 for integral data. |
NUMERIC_SCALE | short | n | scale of the data. |
DATETIME_PRECISION | short | n | precision of the timestamp |
SHORT_NAME | char(2) | y | Adabas short name |
MU_POS | short | y | Position of the column within an Adabas MU field. |
COLUMN_LEVEL | short | n | 0 = non MU/PE column, 1 = top level MU or PE, 2 = MU within PE |
COLUMN_TYPE | enumeration | n | always returns "Ordinary" |
CHARACTER_SET_CATALOG | identifier | n | character set of the catalog (currently not used) |
CHARACTER_SET_SCHEMA | identifier | n | character set of the schema (currently not used) |
CHARACTER_SET_NAME | identifier | n | character set of the name (currently not used) |
COLLATION_CATALOG | identifier | n | collation of the catalog (currently not used) |
COLLATION_SCHEMA | identifier | n | collation of the schema (currently not used) |
COLLATION_NAME | identifier | n | collation of the name (currently not used) |
DOMAIN_CATALOG | identifier | n | domain name of the catalog (currently not used) |
DOMAIN_SCHEMA | identifier | n | domain name of the schema (currently not used) |
DOMAIN_NAME | identifier | n | domain name (currently not used) |