Object documentationSCHEMAS Locate this document in the navigation structure

 

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

Structure

SCHEMAS

OWNER

CHAR(32)

Name of the owner of the schema

SCHEMANAME

CHAR(32)

Name of the schema

SCHEMAHANDLE

FIXED(10)

ID of the schema

CREATEDATE

DATE

Creation data of the schema

CREATETIME

TIME

Creation time of the schema

COMMENT

CLOB

Comments on the schema

More Information

SQL Reference Manual, Schema Name (schema_name),

Database Administration in CCMS, Schemas