# 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

Parent topic: Derby System Tables
Related reference
SYSALIASES
SYSCHECKS
SYSCOLPERMS
SYSCOLUMNS
SYSCONGLOMERATES
SYSCONSTRAINTS
SYSDEPENDS
SYSFILES
SYSFOREIGNKEYS
SYSKEYS
SYSROUTINEPERMS
SYSSTATISTICS
SYSSTATEMENTS
SYSTABLEPERMS
SYSTABLES
SYSTRIGGERS
SYSVIEWS