4 SQL DDL Statements for Property Graphs
You can create, revalidate, rename, 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. - Renaming a SQL Property Graph
You can rename an existing SQL property graph using theRENAME
DDL statement. - 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