Column Selection Dialog Box (Visual Database Tools)

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database YesAzure SQL Managed Instance yesAzure Synapse Analytics yesParallel Data Warehouse

Lets you change the Custom view for tables in the database diagram. Custom view shows only the column properties identified by the user.

This dialog box appears when you right-click a table and then choose Modify Custom View from the shortcut menu.


Available columns
Lists all columns existing in the selected database table. The columns listed here depend on the properties of the database table and the type of database. Highlight the desired column and use the arrow buttons to move the columns to the Selected columns box.

Selected columns
Displays the column properties currently defined for the Custom view. Use the arrow buttons to add and remove column properties to the Selected Columns list.

Arrow controls
Use the up and down arrow buttons to move highlighted columns up or down in the Selected columns list.

Use the > and >> arrows to add one or all of the properties to the custom view.

Use the < and << arrows to remove one or all of the properties from the custom view.

Save as default
Replaces the default Custom view with the columns selected in this dialog box. If not selected, the column selection specified in the dialog box will be applied only to the selected table in the database diagram.

Saves the Custom view.

Cancels the modification of Custom view.

See Also

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