IBM Books

Administration Guide


SYSCAT.SCHEMATA

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.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]