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(3483)
Nullable | Reserved. Contains the null value. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.