DROP PROPERTY GRAPH

remove an SQL-property graph

Pre-release documentation. These definitions may change before the final release.

Syntax

DROP PROPERTY GRAPH [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

Syntax diagrams

Read left to right. Branches are choices, bypasses are optional, loops repeat. Select an underlined parameter to open its rule.

Description

DROP PROPERTY GRAPH drops an existing property graph. To execute this command you must be the owner of the property graph.

Parameters

IF EXISTS: Do not throw an error if the property graph does not exist. A notice is issued in this case.
name: The name (optionally schema-qualified) of the property graph to remove.
CASCADE: Automatically drop objects that depend on the property graph, and in turn all objects that depend on those objects (see Section 5.17).
RESTRICT: Refuse to drop the property graph if any objects depend on it. This is the default.

Examples

DROP PROPERTY GRAPH g1;

Compatibility

DROP PROPERTY GRAPH conforms to ISO/IEC 9075-16 (SQL/PGQ), except that the standard only allows one property graph to be dropped per command, and apart from the IF EXISTS option, which is a PostgreSQL extension.

Related entries

Definition snapshot: 2026-09-14T13:14:25.700916+00:00@99e6866c · English manual source