SYSCAT.FULLHIERARCHIES catalog view

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 1. SYSCAT.FULLHIERARCHIES Catalog View
Column Name Data Type Nullable Description
METATYPE CHAR (1)   Relationship type.
  • R = Between structured types
  • U = Between typed tables
  • W = Between typed views
SUB_SCHEMA VARCHAR (128)   Schema name of the subtype, subtable, or subview.
SUB_NAME VARCHAR (128)   Unqualified name of the subtype, subtable, or subview.
SUPER_SCHEMA VARCHAR (128) Y Schema name of the supertype, supertable, or superview.
SUPER_NAME VARCHAR (128) Y Unqualified name of the supertype, supertable, or superview.
ROOT_SCHEMA VARCHAR (128)   Schema name of the table, view, or type that is at the root of the hierarchy.
ROOT_NAME VARCHAR (128)   Unqualified name of the table, view, or type that is at the root of the hierarchy.