Extended Properites under SQL View

I have checked a view statement under Microsoft SQL Server Management Studio and found a page section "Extended Properties". Any idea what's that ? Do I need to specify anything there when creating a view on a SQL database ?
AXISHKAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
yes. go to the properties of the object, and change to the tab "extended properties"
there you can manage the extended properties of the object from the GUI
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you can specify extended properties not only on views, but several objects, even on columns:
http://technet.microsoft.com/en-us/library/ms190243%28v=sql.105%29.aspx
you add them after creating the object (view) using sys.sp_addextendedproperty
0
 
AXISHKAuthor Commented:
Can this be done on GUI of Microsoft SQL Management Studio ? Tks
0
 
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
Extended properties are not required. You can discard it. If you wish to pass some comments related to any objects you can use extended property.
0
 
AXISHKAuthor Commented:
Tks
0
All Courses

From novice to tech pro — start learning today.