SCHEMAS

Definition

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

Structure

SCHEMAS

OWNER

CHAR(32)

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

See also:

SQL Reference Manual, Schema Name (schema_name)