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 the CREATE PROPERTY GRAPH DDL statement, you can create a property graph object directly in an Oracle AI Database.

• Adding a Comment to a SQL Property Graph
  Using the COMMENT ON PROPERTY GRAPH DDL statement, you can add a comment to a property graph object in Oracle AI Database.

• Revalidating a SQL Property Graph
  Using the ALTER 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 the RENAME DDL statement.

• Dropping a SQL Property Graph
  Using the DROP PROPERTY GRAPH DDL statement, you can remove a property graph object in Oracle AI 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.