Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chih
Posting Yak Master
154 Posts |
 Posted - 2007-02-27 : 17:35:13
|
| Hi ,Is there a query statement that I can retrieve a attribute description from table column property? |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2007-02-27 : 18:57:31
|
| Although it is SQL 2000, I think the fucntion fn_listextendedproperty might work for you.Here is a link to some info from MS:[url]http://msdn2.microsoft.com/en-us/library/aa174648(SQL.80).aspx[/url] |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-02-27 : 23:16:42
|
you can also do this:select * from sys.extended_properties where ...
www.elsasoft.org |
|
|
|
|
|
|
Help- use query to get table structure