Add Related Tables to Diagrams (Visual Database Tools)
You can quickly add to a database diagram all of the tables that are involved in a relationship with a selected table.
To add related tables to a diagram
Add the table with relationships to a database diagram.
Right-click the table and from the shortcut menu and click Add Related Tables.