How to: Add Related Tables to Diagrams
You can quickly add to a database diagram all of the tables that are involved in a relationship with a selected table.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Visual Studio Settings.
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.