Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getting Columns Information with Extended properties
Message
 
À
13/09/2002 12:37:45
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00700170
Message ID:
00700367
Vues:
11
Thanks a million!

By the way, should a developper use information_schema instead of systables?

>Run
>
>sp_helptext 'SP_MsHelpColumns'
>
>from the master database. The results will be the source for sp_MsHelpColumns.
>
>-Mike
>
>>I am currently using this store proc to get columns information : SP_MsHelpColumns because with this one I get the COL_LEN and COL_SCALE.
>>I cannot have this information from INFORMATION_SCHEMA.Columns nor SP_Columns
>>And I use fn_listextendedproperty to retreive extended properties.
>>
>>Is there a way to combine the SP_MsHelpColumns with the fn_listextendedproperty in one single SQL statement?
>>
>>Or What's the SQL statement behind SP_MsHelpColumns?
Luc Nadeau
lnadeau@neova.ca

"the theory, it is when all is known and that nothing works. The practice, it is when all works and that nobody knows why." - Albert Einstein (Nobel of physique 1921)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform