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