SYSSCHEMAS

Describes all schemas in the distributed system.

Table 1. 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
DEFAULTSERVERGROUPS VARCHAR 128 No The default server group(s) to use for tables in the schema