Customize the amount of information displayed in diagrams (Visual Database Tools)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Analytics Platform System (PDW)

When you add a table to a database diagram it appears with a set number of properties showing. You can choose from a menu of variations on how much information shows or you can create a custom set of properties.

The options are:

• Standard
• Column Names
• Keys
• Name Only
• Custom
• Modify Custom

Choose a table view

1. Right-click a table in the Database Diagram Designer.

2. From the shortcut menu, point to Table View and then select the view you want.

Create a custom table view

1. Right-click a table in Database Diagram Designer.

2. From the shortcut menu, point to Table View and then select Modify Custom.

3. In the Column Selection dialog box, choose which properties you want to show when Custom in chosen from the Table View menu.

Related content

• Work with database diagrams (Visual Database Tools)