Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Available Indices in remote tables
Message
 
 
À
15/08/2002 09:27:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00689924
Message ID:
00689983
Vues:
30
>Hi,
>
>There is a way (via a VFP program) to know what indices where created for a given SQL Server or Oracle table?
>
>TIA
>
>Fernando

Fernando,
If you know the back-end you are working with, you can branch two routes to get this information.

For SQL Server:
* lnconn is a valid RDBMS connection
sqlexec(lnconn,[exec sp_helpindex 'MyTable'], 'c_indexes')
For Oracle:
* lnconn is a valid RDBMS connection
sqlexec(lnconn,[select * from user_indexes where upper(table_name) = 'MYTABLE'], 'c_indexes')
HTH.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform