ALL_PG_EDGE_RELATIONSHIPS

4.9 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_RELATIONSHIPS describes edge relationships in all property graphs in the database.
USER_PG_EDGE_RELATIONSHIPS describes edge relationships in the property graphs owned by the current user. This view does not display the OWNER column.

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 Database 23ai.