Hi!
I never remember these things because there is nice tool called GENDBC. I just look to its code to see how it strips out all these indexes and information about them. Or, I just generate the RG file for database, strip out only code for indexing, than use that code to recreate all indexes in database ;)
HTH.
>Hello world,
>
>I would like to get all the information on the indexes in a database so I can recreate the indexes from scratch.
>
>I have two purposes, 1) thoroughly "reindex" the tables, and 2) back up the tables without the indexes, and then rebuild the indexes in the event of a restore. Concerning 1), Menachem Bazian has written that CDX files can bloat, and this can only be remedied with DELETE TAG ALL, after which one must reconstruct the persistent relations in the database. Concerning 2), I have a back up bottleneck, and it would be convenient to eliminate the CDX files from the back up set.
>
>I can get the tag names and kex expressions from the TAG() and KEY() functions. I can get the primary key tag with dbGetProp(). How do I get the order (ascending or descending), the index type (candidate, unique, regular) for non-primary tags, and whether there is a filter?
>
>Any general comments, suggestions or caveats conerning this approach?
>
>Thanks,
>
>Rick Graves (displaced American currently residing in Hong Kong)
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.