Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find Description of a column of a table
Message
 
 
To
09/12/2005 23:16:47
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01076012
Message ID:
01076836
Views:
42
This message has been marked as the solution to the initial question of the thread.
See fn_listextendedproperty system function in BOL
SELECT   *
FROM   ::fn_listextendedproperty ('MS_Description', 'user', 'dbo', 'table', 'T1', 'column', default)
>>SELECT * FROM pubs.INFORMATION_SCHEMA.Columns
>*--------------------------------------------------------
>Dear Sergey,
> Thanks for reply.Maybe I should make what i want more clear.
>If you design a table with the Table Designer,you will find there is
>a Description property for a Column on the top line of lower panel,i
>mean where the property value is restored in some one system table.
>Looking forward to your further help. ;)
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform