Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Available Indices in remote tables
Message
 
To
15/08/2002 10:33:22
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00689924
Message ID:
00689988
Views:
22
>Thanks again, George,
>
>>That's probably it. SQL-DMO is part of the administrative tools and is very powerful. I don't know of a method, that returns this information. SQLCOLUMNS() comes close, but doesn't appear to indicate whether or not a column is part of an index.
>
>The problem is that I have to keep asking to the DBA (and count on his good will to respond), and things don't go as faster as I would like to, so I was trying some kind of VFP way of doing it, if that's possible.
>
Fernando,

I think that Sergey's response might be of use. I've never used sp_helpindex. It's part of the master database. Since the documentation indicates that it works with the current database, I'd assume that you'd have to copy it to each of the databases you wished to use it with. I could be wrong about this, however.
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform