COLUMNS

Information on all the columns for which the current authorization identifier has privileges.

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 or view

COLUMN_NAME

CHAR (31)

Column name

ORDINAL_POSITION

SMALLINT

Sequence number of the column in the
table

COLUMN_DEFAULT

VARCHAR (256)

For base tables only:

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 NULL values 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

CHARACTER_OCTET
_LENGTH

SMALLINT

Max. length of the column in bytes

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

CHARACTER_SET
_CATALOG

CHAR (18)

Database name

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

NULL value in all other cases

CHARACTER_SET
_SCHEMA

CHAR (31)

INFORMATION_SCHEMA

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

NULL value in all other cases

CHARACTER_SET
_NAME

CHAR (18)

EBCDIC

if data type is CHARACTER or
CHARACTER VARYING

UTF16

if data type is NATIONAL CHAR or
NATIONAL CHAR VARYING

NULL value in all other cases

COLLATION_
CATALOG

CHAR (18)

Database name

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

NULL value in all other cases

COLLATION_SCHEMA

CHAR (31)

INFORMATION_SCHEMA

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

NULL value in all other cases

COLLATION_NAME

CHAR (18)

EBCDIC_BINARY

if data type is CHARACTER or
CHARACTER VARYING

UTF16_BINARY

if data type is NATIONAL CHAR or
NATIONAL CHAR VARYING

NULL value in all other cases

DOMAIN_CATALOG

CHAR (18)

NULL value

DOMAIN_SCHEMA

CHAR (31)

NULL value

DOMAIN_NAME

CHAR (31)

NULL value

FIRST_OCCURRENCE

SMALLINT

First possible occurrence of a multiple
column (for base table = 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 69: COLUMNS view of the INFORMATION_SCHEMA (section 4 of 4)