The SQLCOLUMNS view contains one row for every column in a table, view, or
alias. The following table describes the columns in the view:
Column Name | Data Type | Description |
---|---|---|
TABLE_CAT | VARCHAR(128) | Relational database name. |
TABLE_SCHEM | VARCHAR(128) | Name of the SQL schema that contains the table. |
TABLE_NAME | VARCHAR(128) | Table name. |
COLUMN_NAME | VARCHAR(128) | Column name. |
DATA_TYPE | SMALLINT | The data type of the column:
|
TYPE_NAME | VARCHAR(128) | The name of the data type of the column:
|
COLUMN_SIZE | INTEGER | The length of the column. |
BUFFER_LENGTH | INTEGER | Indicates the length of the column in a buffer. |
DECIMAL_DIGITS | SMALLINT
Nullable | Indicates the number of digits for a numeric column.
Contains the null value if the object is not numeric. |
NUM_PREC_RADIX | SMALLINT
Nullable | Indicates the radix of a numeric column.
Contains the null value if the object is not numeric. |
NULLABLE | SMALLINT | Indicates whether the column can contain the null value.
|
REMARKS | VARCHAR(2000)
Nullable | A character string supplied with the COMMENT statement.
Contains the null value if there is no long comment. |
COLUMN_DEF | VARCHAR(2000)
Nullable | The default value of the column.
Contains the null value if there is no default value. |
SQL_DATA_TYPE | SMALLINT | Indicates the SQL data type of the column. |
SQL_DATETIME_SUB | SMALLINT
Nullable | The datetime subtype of the data type:
Contains the null value if the column is not a datetime data type. |
CHAR_OCTET_LENGTH | INTEGER
Nullable | Indicates the length in characters of the column.
Contains the null value if the column is not a string. |
ORDINAL_POSITION | INTEGER | Indicates the ordinal position of the column in the table. |
IS_NULLABLE | VARCHAR(3) | Indicates whether the column can contain the null value.
|
JDBC_DATA_TYPE | SMALLINT | Indicates the JDBC data type of the column.
|
SCOPE_CATALOG | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
SCOPE_SCHEMA | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
SCOPE_TABLE | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
SOURCE_DATA_TYPE | VARCHAR(128)
Nullable | The source data type if the data type of the column is a distinct
type.
Contains the null value if the data type is not a distinct type. |
DBNAME | VARCHAR(8)
Nullable | Reserved. Contains the null value. |
PSEUDO_COLUMN | SMALLINT | Indicates whether this is a ROWID or identity column.
|
COLUMN_TEXT | VARCHAR(50)
Nullable | The text of the column.
Contains the null value if the column has no column text. |
SYSTEM_COLUMN_NAME | CHAR(10) | The system name of the column. |
I_DATA_TYPE | SMALLINT | Indicates the iSeries CLI data type of the column.
|
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.