In MySQL Workbench, how do you set up a cascading delete on a relationship?
在MySQL Workbench中,如何在关系上设置级联删除?
I clicked the relationship line and clicked on properties but I do not see any mention of a cascading delete option.
我单击了关系行并单击了属性,但没有看到任何提到级联删除选项。
1 个解决方案
#1
31
Right Click On Table -> Alter Table -> Foreign Keys Tab
右键单击表-> Alter Table ->外键选项卡
Look at the upper-right corner "Foreign Key Options", there are two drop down boxes, one is to specify the delete action: "On Delete"
看看右上角的“外键选项”,有两个下拉框,一个是指定删除操作:“On delete”
#1
31
Right Click On Table -> Alter Table -> Foreign Keys Tab
右键单击表-> Alter Table ->外键选项卡
Look at the upper-right corner "Foreign Key Options", there are two drop down boxes, one is to specify the delete action: "On Delete"
看看右上角的“外键选项”,有两个下拉框,一个是指定删除操作:“On delete”