Columns View
Describes the columns of the tables defined in the catalog.
This view is part of the ANSI SQL-2 standard Information Schema.

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)