Solved

column comments

Posted on 2011-09-20
5
166 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Suggested Solutions

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

759 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now