Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Find Description of a column of a table
Message
 
 
À
09/12/2005 23:16:47
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01076012
Message ID:
01076836
Vues:
40
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform