SCHEMATA

Information on all the schemas that belong to the current authorization identifier.

Column name	Data type	Contents
CATALOG_NAME	CHAR (18)	Database name
SCHEMA_NAME	CHAR (31)	Name of the schema
SCHEMA_OWNER	CHAR (18)	Authorization identifier of the owner
DEFAULT_CHARACTER_ SET_CATALOG	CHAR (18)	Database name
DEFAULT_CHARACTER_ SET_SCHEMA	CHAR (31)	INFORMATION_SCHEMA
DEFAULT_CHARACTER_ SET_NAME	CHAR (18)	EBCDIC

Table 88: SCHEMATA view of the INFORMATION_SCHEMA