SYSCAT.SCHEMATA catalog view

Each row represents a schema.

Table 1. SYSCAT.SCHEMATA Catalog View
Column Name	Data Type	Nullable	Description
SCHEMANAME	VARCHAR (128)		Name of the schema.
OWNER	VARCHAR (128)		Authorization ID of the owner of the schema.
OWNERTYPE	CHAR (1)		S = The owner is the system U = The owner is an individual user
DEFINER	VARCHAR (128)		Authorization ID of the definer of the schema or authorization ID of the owner of the schema if the ownership of the schema has been transferred.
DEFINERTYPE	CHAR (1)		S = The definer is the system U = The definer is an individual user
CREATE_TIME	TIMESTAMP		Time at which the schema was created.
AUDITPOLICYID	INTEGER	Y	Identifier for the audit policy.
AUDITPOLICYNAME	VARCHAR (128)		Name of the audit policy.
AUDITEXCEPTIONENABLED	CHAR (1)		Reserved for future use.
DATACAPTURE	CHAR (1)		Indicates the default data capture setting for new tables that are created within this schema. N = New tables do not participate in data capture Y = New tables participate in data capture, including replication of all columns
ROWMODIFICATIONTRACKING	VARCHAR (1)	N	Indicates tables in schema are enabled for logical backup Y = Indicates the schema is enabled for row modification tracking N = Indicates the schema is not enabled for row modification tracking
QUIESCED	VARCHAR (1)	N	Indicates the schema is locked by the in-progress LOGICAL_RESTORE operation Y = Indicates the schema is locked by in-progress LOGICAL_RESTORE operation N =Indicates the schema is not locked by in-progress LOGICAL_RESTORE operation
REMARKS	VARCHAR (254)	Y	User-provided comments, or the null value.