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.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
METATYPE | CHAR (1) | Relationship type.
|
|
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. |