ALL_PG_EDGE_RELATIONSHIPS
ALL_PG_EDGE_RELATIONSHIPS describes edge relationships in the property graphs accessible to the current user.
This view displays one row for each key column used for an edge relationship. For example, an edge table defined as follows will result in two rows in this view:
EDGE TABLES(et1 SOURCE KEY(cx, cy) REFERENCES vt1(fk1, fk2) … )
Related Views
-
DBA_PG_EDGE_RELATIONSHIPSdescribes edge relationships in all property graphs in the database. -
USER_PG_EDGE_RELATIONSHIPSdescribes edge relationships in the property graphs owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the property graph |
GRAPH_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the property graph |
EDGE_TAB_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the edge table |
VERTEX_TAB_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the vertex table |
EDGE_END |
VARCHAR2(11) |
Indicates whether the vertex table is a source vertex table (SOURCE) or a destination vertex table (DESTINATION) |
|
EDGE_COL_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the foreign column in the edge table |
VERTEX_COL_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the referenced column in the vertex table |
Note: This view is available starting with Oracle AI Database 26ai.
See Also: