Solved

Extended Properites under SQL View

Posted on 2014-09-21
5
115 Views
Last Modified: 2014-10-07
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
Comment
Question by:AXISHK
  • 2
  • 2
5 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 40336044
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
 

Author Comment

by:AXISHK
ID: 40336122
Can this be done on GUI of Microsoft SQL Management Studio ? Tks
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 300 total points
ID: 40336194
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
 
LVL 21

Assisted Solution

by:Alpesh Patel
Alpesh Patel earned 200 total points
ID: 40336237
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
 

Author Closing Comment

by:AXISHK
ID: 40365783
Tks
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question