SCHEMATA
The SCHEMATA view contains one row for each schema.
The following table describes the columns in the view:
| Column Name | Data Type | Description |
|---|---|---|
| CATALOG_NAME | VARCHAR(128) | Relational database name |
| SCHEMA_NAME | VARCHAR(128) | Name of the schema |
| SCHEMA_OWNER | VARCHAR(128) | Owner of the schema |
| DEFAULT_CHARACTER_SET_CATALOG | VARCHAR(128) | Relational database name |
| DEFAULT_CHARACTER_SET_SCHEMA | VARCHAR(128) | The schema name of the default character set. Contains 'SYSIBM'. |
| DEFAULT_CHARACTER_SET_NAME | VARCHAR(128) | The default character set name. |
| SQL_PATH | VARCHAR(4096) Nullable |
Reserved. Contains the null value. |