Skip to content

Latest commit

 

History

History
55 lines (38 loc) · 1.71 KB

File metadata and controls

55 lines (38 loc) · 1.71 KB
title Customize the Amount of Information Displayed in Diagrams
ms.custom seo-lt-2019
ms.date 01/19/2017
ms.prod sql
ms.prod_service sql-tools
ms.technology ssms
ms.topic conceptual
helpviewer_keywords
database diagrams [SQL Server], information displayed
table views in database diagrams [SQL Server]
customizing database diagram information [SQL Server]
custom table views [SQL Server]
ms.assetid 31bb6772-7974-4329-bca0-c16d5875483d
author markingmyname
ms.author maghan
ms.manager jroth
ms.reviewer

Customize the Amount of Information Displayed in Diagrams (Visual Database Tools)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] 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 choices are:

  • Standard

  • Column Names

  • Keys

  • Name Only

  • Custom

  • Modify Custom

To 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 click the view you want.

To 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 click 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.

See Also

Work with Database Diagrams (Visual Database Tools)