How to set up cascading deletes in MySQL workbench?

Question

In MySQL Workbench, how do you set up a cascading delete on a relationship?

I clicked the relationship line and clicked on properties but I do not see any mention of a cascading delete option.

What version of MySql workbench are you using? – J Cooper Feb 10 '12 at 00:23 — J Cooper, Feb 10 '12 at 00:23

score 54 · Accepted Answer · answered Feb 10 '12 at 00:33

54

Right Click On Table -> Alter Table -> Foreign Keys Tab

Look at the upper-right corner "Foreign Key Options", there are two drop down boxes, one is to specify the delete action: "On Delete"

enter image description here

answered Feb 10 '12 at 00:33

J Cooper

i dont understand why they dont add this to the other FK view too – Murilo Dec 01 '20 at 05:48

1 Answers1