SQL Reference

SYSCAT.FULLHIERARCHIES

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

Table 56. SYSCAT.FULLHIERARCHIES 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)