SYSSCHEMAS System Table

The SYSSCHEMAS table describes the schemas within the current database.

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

SYSSCHEMAS system table
Column Name Type Length Nullable Contents
SCHEMAID CHAR 36 NO Unique identifier for the schema
SCHEMANAME VARCHAR 128 NO Schema name
AUTHORIZATIONID VARCHAR 128 NO The authorization identifier of the owner of the schema

See Also