Show TOC

SCHEMASLocate this document in the navigation structure

Definition

The system table DOMAIN.SCHEMAS describes the schemas known to the database.

Structure

OWNER

CHAR(32)

Name of the owner of the schema

SCHEMANAME

CHAR(32)

Name of the schema

SCHEMAHANDLE

FIXED(10)

Identification of the schema

CREATEDATE

DATE

Creation data of the schema

CREATETIME

TIME

Creation time of the schema

COMMENT

CLOB

Comments on the schema

PARTITIONID

FIXED(5)

Identification of the partition

More Information

SQL Reference Manual, Schema Name (schema_name),

Database Administration in CCMS, Schemas