duckpgq-extension
duckpgq-extension copied to clipboard
Altering existing property graph syntax
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>
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.