SQL Reference

SYSCAT.HIERARCHIES

Each row represents the relationship between a subtable and its immediate supertable, a subtype and its immediate supertype, or a subview and its immediate superview. Only immediate hierarchical relationships are included in this view.

Table 63. SYSCAT.HIERARCHIES Catalog View

Column Name	Data Type	Nullable	Description
METATYPE	CHAR(1)		Encodes the type of relationship: R = Between structured types U = Between typed tables W = Between typed views
SUB_SCHEMA	VARCHAR(128)		Qualified name of subtype, subtable, or subview.
SUB_NAME	VARCHAR(128)
SUPER_SCHEMA	VARCHAR(128)		Qualified name of supertype, supertable, or superview.
SUPER_NAME	VARCHAR(128)
ROOT_SCHEMA	VARCHAR(128)		Qualified name of the table, view or type that is at the root of the hierarchy.
ROOT_NAME	VARCHAR(128)