如何在MySQL workbench中设置级联删除?

时间:2021-01-27 22:10:54

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”

如何在MySQL workbench中设置级联删除?

#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”

如何在MySQL workbench中设置级联删除?