Setting Extended Properties from Object Browser

Extended properties are properties that you can define on various objects in the database. Object Browser provides access to the Extended Property dialog box, where you can view existing properties for the selected object or define new properties.

To view or define extended properties for an object

1. In Object Browser, expand a server, and then expand a database.
   
   
2. Right-click the object and then click Extended properties.

To define a new property, enter a name for the property in the name box and a property value in the value box.