The SQLSPECIALCOLUMNS view contains one row for every column of a primary key, unique constraint, or unique index that can identify a row of the table.
The following table describes the columns in the view:
| Column Name | Data Type | Description |
|---|---|---|
| SCOPE | SMALLINT | Reserved. Contains 0. |
| COLUMN_NAME | VARCHAR(128) | Column name |
| DATA_TYPE | SMALLINT | The data type of the column:
|
| TYPE_NAME | VARCHAR(260) | 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 column is not numeric. |
| PSEUDO_COLUMN | SMALLINT | Indicates whether this is a ROWID,
identity, or row change timestamp column.
|
| TABLE_CAT | VARCHAR(128) | Relational database name |
| TABLE_SCHEM | VARCHAR(128) | Name of the SQL schema that contains the table. |
| TABLE_NAME | VARCHAR(128) | Name of the table. |
| NULLABLE | SMALLINT | Indicates whether the column can
contain the null value.
|
| JDBC_DATA_TYPE | SMALLINT | Indicates the JDBC data type of the
column.
|
| I_DATA_TYPE | SMALLINT | Indicates the IBM® i CLI data type of the column.
|