How do you delete a many to many association in ecto?

Question

It's not clear to me how to delete a many to many association in Ecto. I do not want to delete the associated structures, just the relationship.

My first attempt was to find the association in join_through table and delete it, but there is no primary key so Repo.delete fails.

you can define a :on_delete option that specifies which action should be performed on associations when the parent is deleted: Ecto docs has_many/3 — Pascal
I don't want to delete the parent. I want to delete the association itself — Fletcher Moore
Have you tried Repo.delete_all/2 with a query on the join table and both foreign keys? — Martin Svalin

Unknown Unknown · Accepted Answer · 2016-11-10T16:44:04

Repo.delete_all/2 with a query on the join table and both foreign keys.