The COLUMNS view contains one row for every column. The following
table describes the columns in the view:
Column Name | Data Type | Description |
---|---|---|
TABLE_CATALOG | VARCHAR(128) | Relational database name |
TABLE_SCHEMA | VARCHAR(128) | Name of the SQL schema containing the table or view |
TABLE_NAME | VARCHAR(128) | Name of the table or view that contains the column |
COLUMN_NAME | VARCHAR(128) | Name of the column |
ORDINAL_POSITION | INTEGER | Numeric place of the column in the table or view, ordered from left to right |
COLUMN_DEFAULT | VARCHAR(2000)
Nullable | The default value of a column, if one exists. If the default value
of the column cannot be represented without truncation, then the value of the
column is the string 'TRUNCATED'. The default value is stored
in character form. The following special values also exist:
Contains the null value if:
|
IS_NULLABLE | VARCHAR(3) | Indicates whether the column can contain null values:
|
DATA_TYPE | VARCHAR(128) | Type of column:
|
CHARACTER_MAXIMUM_LENGTH | INTEGER
Nullable | Maximum length of the string for binary, character and graphic string
data types.
Contains the null value if the column is not a string. |
CHARACTER_OCTET_LENGTH | INTEGER
Nullable | Number of bytes for binary, character and graphic string data
types.
Contains the null value if the column is not a string. |
NUMERIC_PRECISION | INTEGER
Nullable | The precision of all numeric columns.
Contains the null value if the column is not numeric. |
NUMERIC_PRECISION_RADIX | INTEGER
Nullable | Indicates if the precision specified in column NUMERIC_PRECISION is
specified as a number of binary or decimal digits
Contains the null value if the column is not numeric. |
NUMERIC_SCALE | INTEGER
Nullable | Scale of numeric data.
Contains the null value if the column is not decimal, numeric, or binary. |
DATETIME_PRECISION | INTEGER
Nullable | The fractional part of a date, time, or timestamp.
Contains the null value if the column is not a date, time, or timestamp. |
INTERVAL_TYPE | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
INTERVAL_PRECISION | INTEGER
Nullable | Reserved. Contains the null value. |
CHARACTER_SET_CATALOG | VARCHAR(128)
Nullable | Relational database name
Contains the null value if the column is not a string. |
CHARACTER_SET_SCHEMA | VARCHAR(128)
Nullable | The schema name of the character set. Contains SYSIBM.
Contains the null value if the column is not a string. |
CHARACTER_SET_NAME | VARCHAR(128)
Nullable | The character set name.
Contains the null value if the column is not a string. |
COLLATION_CATALOG | VARCHAR(128)
Nullable | Relational database name
Contains the null value if the column is not a string. |
COLLATION_SCHEMA | VARCHAR(128)
Nullable | The schema of the collation. Contains SYSIBM.
Contains the null value if the column is not a string. |
COLLATION_NAME | VARCHAR(128)
Nullable | The collation name. Contains IBMBINARY.
Contains the null value if the column is not a string. |
DOMAIN_CATALOG | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
DOMAIN_SCHEMA | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
DOMAIN_NAME | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
UDT_CATALOG | VARCHAR(128)
Nullable | The relational database name if this is a distinct type.
Contains the null value if this is not a distinct type. |
UDT_SCHEMA | VARCHAR(128)
Nullable | The name of the schema if this is a distinct type.
Contains the null value if this is not a distinct type. |
UDT_NAME | VARCHAR(128)
Nullable | The name of the distinct type.
Contains the null value if this is not a distinct type. |
SCOPE_CATALOG | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
SCOPE_SCHEMA | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
SCOPE_NAME | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
MAXIMUM_CARDINALITY | INTEGER
Nullable | Reserved. Contains the null value. |
DTD_IDENTIFIER | VARCHAR(128)
Nullable | A unique internal identifier for the column. |
IS_SELF_REFERENCING | VARCHAR(3) | Reserved. Contains 'NO'. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.