DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.HIERARCHIES catalog view

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 1. SYSCAT.HIERARCHIES 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)   Schema name of the supertype, supertable, or superview.
SUPER_NAME VARCHAR (128)   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.