Add Related Tables to Diagrams (Visual Database Tools)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Analytics Platform System (PDW)
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.