Rename a Relationship

You can rename a relationship. When you rename a relationship, the relationship name is automatically updated in the current database diagram and any other database diagram in which it appears.

1. In the Database window, click Database Diagrams   under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
2. In your database diagram, select the line representing the relationship that you want to rename.
3. Right-click the relationship line and select Properties.
4. Choose the Relationships tab.
5. In the Relationship name box, type a new name.

The relationship is renamed in the database diagram and any other database 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 database diagram.