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.

Solution

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"

Comments

[Murilo]

i dont understand why they dont add this to the other FK view too