Column Selection Dialog Box (Visual Database Tools)

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.

Options

  • 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.
  • OK
    Saves the Custom view.
  • Cancel
    Cancels the modification of Custom view.

See Also

Other Resources

Working with Database Diagrams (Visual Database Tools)
How to: Customize the Amount of Information Displayed in Diagrams (Visual Database Tools)

Help and Information

Getting SQL Server 2005 Assistance