The following table shows the contents of the SYSSCHEMAS system table.
SYSSCHEMAS system table
For each column in the SYSSCHEMAS system table, this table provides its data type, its length in bytes, whether it is nullable, and a description of its contents.
Column Name
Type
Length
Nullable
Contents
SCHEMAID
CHAR
36
false
Unique identifier for the schema
SCHEMANAME
VARCHAR
128
false
Schema name
AUTHORIZATIONID
VARCHAR
128
false
The authorization identifier of the owner of the schema