The SQLSCHEMAS view contains one row for every schema.
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 schema. |
| TABLE_NAME | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| TABLE_TYPE | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| REMARKS | VARGRAPHIC(2000) CCSID
1200Nullable ![]() |
Reserved. Contains the null value. |
| TYPE_CAT | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| TYPE_SCHEM | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| TYPE_NAME | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| SELF_REFERENCING_COL_NAME | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| REF_GENERATION | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| DBNAME | VARCHAR(8) Nullable |
Reserved. Contains the null value. |
| SCHEMA_TEXT | VARGRAPHIC(50) CCSID
1200Nullable ![]() |
A character string that describes the schema. Contains the empty string if there is no text. |
| SYSTEM_TABLE_SCHEMA | CHAR(10) | System schema name. |