4.12 ALL_PG_KEYS

ALL_PG_KEYS describes key columns in the property graphs accessible to the current user.

Related Views

  • DBA_PG_KEYS describes key columns in all property graphs in the database.

  • USER_PG_KEYS describes key columns 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

ELEMENT_NAME

VARCHAR2(128)

NOT NULL

Name of the element table

COLUMN_NAME

VARCHAR2(128)

NOT NULL

Name of the column used to define the key

Note:

This view is available starting with Oracle Database 23ai.

See Also: