SYSSCHEMAS

The SYSSCHEMAS view contains one row for every schema in the relational database.

The following table describes the columns in the SYSSCHEMAS view:

Table 1. 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.
Start of changeIASP_NUMBEREnd of change Start of changeIASPNUMBEREnd of change Start of changeSMALLINTEnd of change Start of changeSpecifies the independent auxiliary storage pool (IASP) number.End of change