Options (Environment/Fonts and Colors Page)

The Options dialog box lets you establish a custom font and color scheme for various user interface elements in Microsoft SQL Server Management Studio. On the Tools menu, click Options, expand the Environment folder, and select Fonts and Colors.

Color scheme changes do not take effect during the session in which you make them. You can evaluate color changes by opening another instance of SQL Server Management Studio and producing the conditions under which you expect your changes to apply.

  • Show settings for
    Lists all the user interface elements for which you can change font and color schemes. After selecting an item from this list you can customize color settings for the item selected in Display items.

    Term

  • Use Defaults
    The Use Defaults button resets the value for the default font and color values of the list item that you selected from the Show settings for list.
  • Font (bold type indicates fixed-width fonts)
    Lists all the fonts installed on your system. When this drop-down list is first opened, the current font for the element you chose from the Show settings for list is selected. Fixed fonts — which are easier to align in an editor — appear in bold.
  • Size
    Lists available point sizes for the selected font. Changing the size of the font affects all Display items entries for a Show settings for selection.
  • Display items
    Lists the items for which you can modify the foreground and background color.

    Note

    The default display item is Text. As such, properties assigned to Text will be overridden by properties assigned to other display items. For example, if you assign the color blue to Text and the color green to Identifier, all identifiers will appear in green. In this example, Identifier properties override Text properties.

    Some display items include:

    • Indicator Margin: The margin at the left of the Code Editor where breakpoints and bookmark icons are displayed.
    • Collapsible Text: A block of text or code that can be switched into and out of view within the Code Editor (XML only).
  • Item foreground
    Lists the available colors you can choose for the foreground of the item selected in Display items. Because some items are related, a consistent display scheme should be maintained; for example, changing the foreground color of text also changes the foreground color for elements such as String.
  • Custom
    Displays the Color dialog box, where you set a custom color for the item selected in the Display items list.

    Note

    Your ability to define custom colors may be limited by the color settings for your computer display. For example, if your computer is set to display 256 colors and you select a custom color from the Color dialog box, SQL Server Management Studio chooses to the closest available value in Basic colors as the default, and displays the color black in the Color dialog box.

  • Item background
    Provides a color palette from which you can choose a background color for the item selected in Display items. Because some items are related, a consistent display scheme should be maintained; for example, changing the background color of text also changes the background color for elements such as SQL String.
  • Custom
    Displays the Color dialog box, where you set a custom color for the item selected in the Display items list.
  • Bold
    Select this check box to display the text of selected display items in bold font. Bold text is easier to identify in an editor.
  • Sample
    Displays a sample of the font style, size, and color scheme for the selected values in Show settings for and Display items. You can use this text box to preview the results as you experiment with different formatting options.