Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How I Know if an INDEX TAG exist?
Message
 
 
To
11/03/2002 15:18:43
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00631162
Message ID:
00631166
Views:
24
>How can I know if an INDEX TAG exists?. I want to delete an especific index tag (if it exists, of course) before create a new one.
>
You can use TAGNO() function
IF TAGNO("myindtag") > 0
  * Tag 'myindtag' exists
ENDIF
However it's not good idea to delete and recreate individual indexes because it causes index bloat and slows down data access. Maybe there's another way? Why do you need to delete and recreate an index?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform