Add Delete Rule to GUI when setting Relationships

[Lior539]

Feature request

Right now, when using the GUI to add a relationship between tables you cannot set the delete rule (e.g. cascade). You almost always want to specify the delete rule on the relationship when creating it, but this limitation in the GUI means that effectively the GUI has no use when it comes to setting relationship and you always need to use the SQL editor instead.

See attached screenshot of current GUI:

[sannajammeh]

+1

[ryanrussell]

@Lior539

Echoing this sentiment on referential integrity around cascading deletes, having to go to the editor and do an ALTER TABLE ... DROP CONSTRAINT ... ADD CONSTRAINT to add an on delete cascade seems like it could be made into a checkbox in the GUI.

Please and thank you :)

[cullophid]

👍 this would be fantastic. Right now I had to set up all the relationships in SQL.