Each row represents the immediate subtype/supertype, subtable/supertable,
or subview/superview relationship in the database.
Table 109. OBJCAT.HIERARCHIES Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| METATYPE | CHAR(1) |
| Indicates the type of database objects to which this row is
applicable.
R=relationship between structured types T=relationship between tables V=relationship between views |
| SUB_SCHEMA | CHAR(8) |
| Qualified name of subtype, subtable, or subview. |
| SUB_NAME | VARCHAR(18) |
| |
| SUPER_SCHEMA | CHAR(8) |
| Qualified name of supertype, supertable, or superview. |
| SUPER_NAME | VARCHAR(18) |
|