The system table SCHEMAS describes the schemas known to the database instance.
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)