duckpgq-extension icon indicating copy to clipboard operation
duckpgq-extension copied to clipboard

Altering existing property graph syntax

Open Dtenwolde opened this issue 1 year ago • 1 comments

This issue gathers some syntax ideas to alter an existing property graph.

This is specified in the SQL/PGQ standard: 11.20 <alter property graph statement> Please double-check that the proposed queries here adhere to the standard before implementing this.

ALTER PROPERTY GRAPH <property_graph> ADD VERTEX TABLES (CUSTOMER) 
ALTER PROPERTY GRAPH <property_graph> ADD EDGE TABLES (KNOWS, STUDIES_AT)
ALTER PROPERTY GRAPH <property_graph> ADD VERTEX TABLES (CUSTOMER) EDGE TABLES (KNOWS, STUDIES_AT)
ALTER PROPERTY GRAPH <property_graph> DROP VERTEX TABLES (CUSTOMER)
ALTER PROPERTY GRAPH <property_graph> <table_name (or label?)> ADD PROPERTIES (name)
ALTER PROPERTY GRAPH <property_graph> <table_name (or label?)> DROP PROPERTIES (name)
ALTER PROPERTY GRAPH <property_graph> <table_name (or label?)> RENAME LABEL <new_label>

Dtenwolde avatar Jul 04 '23 07:07 Dtenwolde

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

github-actions[bot] avatar Sep 05 '24 00:09 github-actions[bot]