SQL Reference

SYSCAT.SCHEMATA

Contains a row for each schema.

Table 85. SYSCAT.SCHEMATA Catalog View
Column Name Data Type Nullable Description
SCHEMANAME VARCHAR(128)
Name of the schema.
OWNER VARCHAR(128)
Authorization id of the schema. The value for implicitly created schemas is SYSIBM.
DEFINER VARCHAR(128)
User who created the schema.
CREATE_TIME TIMESTAMP
Timstamp indicating when the object was created.
REMARKS VARCHAR(254) Yes User-provided comment.


[ Top of Page | Previous Page | Next Page ]