SYSSCHEMAS

Describes the schemas within the current database.
Column Name Type Length Nullability 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
Related reference
SYSALIASES
SYSCHECKS
SYSCOLPERMS
SYSCOLUMNS
SYSCONGLOMERATES
SYSCONSTRAINTS
SYSDEPENDS
SYSFILES
SYSFOREIGNKEYS
SYSKEYS
SYSROUTINEPERMS
SYSSTATISTICS
SYSSTATEMENTS
SYSTABLEPERMS
SYSTABLES
SYSTRIGGERS
SYSVIEWS