When deleting a relation column, the warning should state the name of the affected column AND table so it is clear what table is affected. It currently only states the name of the affected column. The text also says “the following places”, but the name of the column is not a place. Because the affected column typically has the same name as the target table being modified, this is extremely ambiguous, and the user has no idea what other table(s) is(are) affected.
Given table Table1 has a relation Table2Item to table Table2
And Table2 has the reverse relation Table1Items
When I delete the relation column Table2Item in Table1
Then I should get the message “Deleting ‘Table2Item’ will also affect references to the column in the following places: ‘Table2 (Table1Items)’”
But instead I get the message “Deleting ‘Table2Item’ will also affect references to the column in the following places: ‘Table1Items’” without any indication of the table where ‘Table1Items’ is located.