The SYSSCHEMAS view contains one row for every schema in the relational database.
The following table describes the columns in the SYSSCHEMAS view:
| Column Name | System Column Name | Data Type | Description |
|---|---|---|---|
| SCHEMA_NAME | NAME | VARCHAR(128) | Name of the SQL schema. |
| SCHEMA_OWNER | OWNER | VARCHAR(128) | Owner of the schema. |
| SCHEMA_CREATOR | CREATOR | VARCHAR(128) | Name of the user that created the schema. |
| CREATION_TIMESTAMP | TIMESTAMP | TIMESTAMP | Timestamp when the schema was created. |
| SCHEMA_SIZE | SIZE | DECIMAL(15,0) | Size of the schema (in bytes). |
| SCHEMA_TEXT | LABEL | VARCHAR(50) Nullable |
A character string supplied with
the LABEL statement. Contains the null value if the schema has no text. |
| SYSTEM_SCHEMA_NAME | SYS_NAME | CHAR(10) | System schema name. |
IASP_NUMBER![]() |
IASPNUMBER![]() |
SMALLINT![]() |
Specifies the independent auxiliary
storage pool (IASP) number.![]() |