Revalidating a SQL Property Graph

4.2 Revalidating a SQL Property Graph

Using the ALTER PROPERTY GRAPH COMPILE DDL statement, you can revalidate an existing property graph object in the database.

A SQL property graph schema may become invalid due to the alteration of the underlying database objects. For instance, adding or dropping a column from the underlying database tables, used in the graph definition, can cause the graph to become invalid. Any invalidation of the graph will also invalidate cursors depending on the graph object. In such a case, you can recover your property graph from an invalid state as shown in the following example. Also, refer to Granting System and Object Privileges for SQL Property Graphs to ensure you have the required privilege to perform the ALTER PROPERTY GRAPH operation.

Example 4-2 Revalidating a SQL Property Graph

ALTER PROPERTY GRAPH students_graph COMPILE;