property-pages-in-sql-server-management-studio.md

title	Property Pages in SQL Server Management Studio
ms.custom	seo-lt-2019
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	sql-tools
ms.reviewer
ms.technology	ssms
ms.topic	conceptual
helpviewer_keywords	property pages [SQL Server Management Studio]
ms.assetid	719282c3-e9cc-4e0e-9a83-7fb8b8b17f67
author	markingmyname
ms.author	maghan

Property Pages in SQL Server Management Studio

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] Property page dialog boxes in [!INCLUDEmsCoName] [!INCLUDEssManStudioFull] all use a common format displaying information with expanding and collapsing categories. The fields shown depend on the particular property. Properties shown in gray are read-only. Categorized and Alphabetic buttons are near the top of each property page.

The following table describes the common elements of [!INCLUDEssManStudio] property page dialog boxes.

Element	Description
Categorized	Lists all properties and property values for the selected object, sorted by category. In category view, you can collapse a category to reduce the number of visible properties. When you expand or collapse a category, you see a plus sign (+) or minus sign (-) to the left of the category name. Categories are listed alphabetically.
Alphabetic	Lists all properties and property values for the selected object, sorted alphabetically.
Property name	The first column in the grid lists the property names.
Properties	The second column in the grid lists the property values.
Description pane	The description pane appears at the bottom of the page and shows the property type and a short description of the property. You can turn the description of the property off and on using the Description command on the shortcut menu.