BASE_TABLE_COLUMNS

Information on base table columns. The current authorization identifier must have at least one column privilege for the column or the UTILITY privilege for the database.

Column name

Data type

Contents

TABLE_CATALOG

CHAR (18)

Database name

TABLE_SCHEMA

CHAR (31)

Name of the schema to which the table
belongs

TABLE_NAME

CHAR (31)

Name of the base table

COLUMN_NAME

CHAR (31)

Column name

ORDINAL_POSITION

SMALLINT

Sequence number of the column in the
table

COLUMN_DEFAULT

VARCHAR (256)

Default value,

as specified in the column definition
(e.g. CHAR literal in single quotes) if
the current authorization identifier
owns the schema

TRUNCATED

if representation of the default value
comprises more than
256 characters and the current
authorization identifier owns the
schema. The default value cannot
be displayed.

NULL value in all other cases

IS_NULLABLE

VARCHAR (3)

NO	Column cannot accept NULLvalues under any circumstances
YES	else

DATA_TYPE

VARCHAR (24)

Data type of the column:
CHARACTER
CHARACTER VARYING
NATIONAL CHAR
NATIONAL CHAR VARYING
REAL
DOUBLE PRECISION
FLOAT
INTEGER
SMALLINT
NUMERIC
DECIMAL
DATE
TIME
TIMESTAMP
OLDEST

CHARACTER
_MAXIMUM_LENGTH

SMALLINT

Max. length of the column in code units

if the data type is CHARACTER,
CHARACTER VARYING,
NATIONAL CHAR, NATIONAL
CHAR VARYING or OLDEST

NULL value in all other cases

NUMERIC_PRECISION

SMALLINT

Total number of significant digits

for numeric data types

NULL value in all other cases

NUMERIC_PRECISION
_RADIX

SMALLINT

Radix

for numeric data types

NULL value in all other cases

NUMERIC_SCALE

SMALLINT

Number of digits right of the decimal
point
for exact numeric data types

NULL value in all other cases

DATETIME_PRECISION

SMALLINT

Number of digits right of the decimal
point

for the data types TIME and
TIMESTAMP

NULL value in all other cases

The columns OLDEST_DESCRIPTOR* are assigned a value if DATA_TYPE is OLDEST:

OLDEST_DESCRIPTOR1

CHAR (1)

Y N	left-aligned not left-aligned

NULL value if DATATYPE is not
OLDEST

OLDEST_DESCRIPTOR2

CHAR (1)

Y N	Fill character No fill character

NULL value if DATATYPE is not
OLDEST

OLDEST_DESCRIPTOR3

CHAR (1)

Y N	Null (0) permitted as value Null (0) not permitted

NULL value if DATATYPE is not
OLDEST

OLDEST_DESCRIPTOR4

CHAR (1)

Y N	Value has arithmetic result Value does not have arithmetic result

NULL value if DATATYPE is not
OLDEST

COLUMN_DESCRIPTOR1

CHAR (1)

Y	Column has exactly one single column index and is not included in a compound index
N	Column has no index or more than one single-column index, or is included in a compound index

COLUMN_DESCRIPTOR2

CHAR (1)

Y	Column has exactly one compound index and no single-column index
N	Column does not have an index, has more than one index, or only one single-column index

COLUMN_DESCRIPTOR3

CHAR (1)

Y	Column has more than one index
N	Column has a maximum of one index

COLUMN_DESCRIPTOR4

CHAR (1)

Y	Column has a CALL DML default value
N	Column does not have a CALL DML default value

COLUMN_DESCRIPTOR5

CHAR (1)

Y	Column is a multiple column
N	Column is an atomic column

PK_DISTANCE

SMALLINT

Distance of the column to the start of the
primary key

NULL value if the column is not in the
primary key

SESAM_SAN

CHAR (3)

Symbolic attribute name of the column

NULL value if the column is defined in
the SQL table

SESAM_DEFAULT

CHAR (2)

CALL DML default (with sign, if
necessary, if numeric data type)

NULL value if the column is defined in
the SQL table

FIRST_OCCURRENCE

SMALLINT

First possible occurrence of a multiple
column (= 1)

NULL value if the column is not multiple

LAST_OCCURRENCE

SMALLINT

Last possible occurrence of a multiple
column

NULL value if the column is not multiple

Table 64: BASE_TABLE_COLUMNS view of the INFORMATION_SCHEMA (section 4 of 4)