Set-null-if-no-cycle-check is wrongly placed for MSSQL?

Is onDelete case of set-null-if-no-cycle-check wrongly placed to use “on delete no action”

No, I don’t think so. What makes you ask?

Owh, the naming for it is set-null but the returned sql is no-action , instead of set null

The key is this ^^. MSSQL has a broken idea of not allowing these cascades in situations where they are perfectly fine due to a “cycle check”. It doesn’t even allow setting null. So in this case we can’t do anything about it and just have to let MSSQL break when the record tries to be deleted.

1 Like

I see, that’s good to know :+1: