SQLSCHEMAS
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
1200 Nullable
|
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
1200 Nullable
|
A character string that describes the schema. Contains the empty string if there is no text. |
SYSTEM_TABLE_SCHEMA | CHAR(10) | System schema name. |