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(261) | 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.
|
| 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 bytes 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 | SMALLINT Nullable |
The source data type if the data
type of the column is a distinct type. For values see JDBC_DATA_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,
identity, or row change timestamp 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 IBM® i CLI data type of the column.
|