Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server view info available?
Message
 
 
À
31/01/2005 14:09:35
Gary Foster
Pointsource Consulting LLC
Chanhassen, Minnesota, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Divers
Thread ID:
00981936
Message ID:
00982623
Vues:
35
Hi Gary,

The INFORMATION_SCHEMA views is the first place to look for SQL Server metadata. The system stored procedures would be the second. I strongnly recomend never access system tables directly in application because MS doesn't guaranty that they wouldn't change them in the next version of MS SQL Server.

>Most Excellent! That saves me from a considerable parsing exercise.
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform