DB2 10.5 for Linux, UNIX, and Windows

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
REMARKS	VARCHAR (254)	Y	User-provided comments, or the null value.