Renaming a Relationship

See Also

You can rename a relationship if you want to abbreviate the system-assigned relationship name, or if you want to replace it with a user-defined name. When you rename a relationship, the relationship name is automatically updated in the current diagram and any other diagram in which it appears.

To rename a relationship

1. In your database diagram, select the line representing the relationship that you want to rename.
   
   
2. Right-click the relationship line and select Properties.
   
   
3. Choose the Relationships tab.
   
   
4. In the Relationship name box, type a new name. Make sure that it doesn’t duplicate any of the names in the Selected relationship list.

The relationship is renamed in the diagram and any other diagram in which it appears as soon as you exit the Relationship name box; it is renamed in the database when you save either of the related tables or the diagram.

Tip   If you want to see labels for relationship lines, use the Show Relationship Labels command. For more information on relationship labels and this command, see Adding Labels to Relationship Lines.