Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sp_refreshview
Message
De
16/02/2005 11:59:32
Gary Foster
Pointsource Consulting LLC
Chanhassen, Minnesota, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Sp_refreshview
Versions des environnements
Visual FoxPro:
VFP 9
Database:
MS SQL Server
Divers
Thread ID:
00987505
Message ID:
00987505
Vues:
59
Hi all,
Does anyone know how to view the code in this sp? I'm looking for view info, a list of fieldname, table and expression that I can't seem to get from information_schema, syscolumns, etc. syscolumns has the field aliases, but not the real fieldname or expression. information_schema.view_column_usage links table-field info but returns more rows than the view has columns. So close but no banana. I'm hoping sp_refreshview can reveal the secret!

Gary
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform