SYSSCHEMAS
The SYSSCHEMAS view contains one row for every schema in the relational database.
For information related to a single schema,
a query that uses table function OBJECT_STATISTICS will perform much
better than querying SYSSCHEMAS. For example:
SELECT *
FROM TABLE (QSYS2.OBJECT_STATISTICS('MJATST ','LIB ')) AS AThe 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 | VARGRAPHIC(50) CCSID
1200 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. |