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 77. SYSCAT.FULLHIERARCHIES Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| METATYPE | CHAR(1) |
| Encodes the type of relationship:
|
| 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) |
|