4 SQL DDL Statements for Property Graphs
You can create, revalidate, and drop SQL property graphs using SQL data definition language (DDL) statements.
- Creating a SQL Property Graph
Using theCREATE PROPERTY GRAPH
DDL statement, you can create a property graph object directly in an Oracle Database. - Revalidating a SQL Property Graph
Using theALTER PROPERTY GRAPH COMPILE
DDL statement, you can revalidate an existing property graph object in the database. - Dropping a SQL Property Graph
Using theDROP PROPERTY GRAPH
DDL statement, you can remove a property graph object in Oracle Database. - JSON Support in SQL Property Graphs
When creating a SQL property graph, you can define a label property over a JSON data type column using simplified dot notation. You can later access this property inside the SQL graph query.
Parent topic: SQL Property Graphs