SYSSCHEMAS system table

The SYSSCHEMAS table describes the schemas within the current database.

The following table shows the contents of the SYSSCHEMAS system table.

Table 1. SYSSCHEMAS system table
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