# 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

Parent topic: Derby system tables