Expand description
The table clauses of CREATE PROPERTY GRAPH: the subset of SQL/PGQ Ursa
supports, and clear errors for the rest.
CREATE [OR REPLACE] PROPERTY GRAPH [IF NOT EXISTS] name
[VERTEX TABLES ( table KEY (column) )]
EDGE TABLES (
table SOURCE KEY (column) [REFERENCES vertex_table (key)]
DESTINATION KEY (column) [REFERENCES vertex_table (key)]
)SQL/PGQ allows more: several vertex and edge tables, AS alias, LABEL,
DEFAULT LABEL, PROPERTIES, NO PROPERTIES, an edge table KEY,
SOURCE vertex_table without KEY, and multi-column keys. Each is
recognised and rejected as not supported yet, never parsed as something
else. NODE TABLES and RELATIONSHIP TABLES, SQL/PGQ’s synonyms, are
accepted.
Structs§
- Edge
Table Def EDGE TABLES (table SOURCE … DESTINATION …).- Endpoint
Def KEY (key) [REFERENCES table (column)], afterSOURCEorDESTINATION.- References
REFERENCES table (column).- Vertex
Table Def VERTEX TABLES (table KEY (key)).