Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 131
  • Last Modified:

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 ?
0
AXISHK
Asked:
AXISHK
  • 2
  • 2
2 Solutions
 
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
 
Guy Hengel [angelIII / a3]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
 
Alpesh PatelAssistant 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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now