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 59. 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)

Column Name	Data Type	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)

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]