Feature: ALTER REL TABLE

[emabiz]

API

Python

Description

Hi,
I don't understand if it is possible to alter a rel table after creation.
From the documentation it seems not possible.

I'd like to add new node pairs referring to the same relationship at any moment.

For example:

CREATE REL TABLE Located(FROM User TO City, FROM Shop TO City);

Now I need to add the same relationship between Event and City.
I'd like to have something like:
ALTER REL TABLE Located ADD IF NOT EXISTS(FROM Event TO City);

I don't like to create a specific new relationship like EventLocated.

In the documentation here:
https://docs.kuzudb.com/cypher/data-definition/create-table/

it is mentioned that children tables are created for managing multiple pairs node, but I don't understand if it possible and how to use them to add the new relationship above.

Is there a way to achieve this?

Thank you

[ray6080]

hi @emabiz we don't support this for now. There is an open issue here on this #5051. Will let you know once we added the support.

[emabiz]

ah ok,
then for now I will try to backup and drop the table, create a new table adding the new relationships, and repopulate the table. Not very efficient but it could work.

Thank you

[andyfengHKU]

This is now supported in #5486