Cloudscape System Tables
Page 13 of 17

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

Indexes

  • SYSSCHEMAS_INDEX1 unique BTREE index on (SCHEMANAME)
  • SYSSCHEMAS_INDEX2 unique BTREE index on (SCHEMAID)