Solved

column comments

Posted on 2011-09-20
5
184 Views
Last Modified: 2012-06-27
which system table/views holds comments of columns?
0
Comment
Question by:25112
  • 3
5 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 36569563
That would be: sys.extended_properties
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 36569570
You can also use the function  fn_listextendedproperty()
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 36573166
stay in sys.extended_properties system table
0
 
LVL 5

Author Comment

by:25112
ID: 36573177
i tried both.. worked.. thx..

>>stay in sys.extended_properties system table
what do you mean?
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 36573235
>>what do you mean? <<
Probably nothing. PatelAlpesh is famous for his/her drive by, meaningless or copied comments without any further feedback.  So I would be surprised if you receive any further response, let alone anything that makes sense.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Writing SQL Select Query result to a text file 12 46
Generate Weekly Schedule 15 28
sql server select date from a datetime column 10 25
Email Notifications for SQL 2005 9 28
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
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.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

770 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