>I would like to have a form which re-indexes tables and/or packs then. This is a single user system so I can get the files in EXCLUSIVE mode for the pack command. What I am not sure off is what the best method is to re-index the tables. What is the best way of determining the existing indexes and re-creating them.
>
>The reason I need to do is is to remove deleted records.
>
>I do a search but could not find what I needed.
>
>TIA
See if this would work for you
Re: Rebuilding indexes Thread #
525867 Message #
525869 or just get tags' info with
ATAGSINFO
function and re-create all indexes based on it. There may be problems with PK/FK though.
If it's not broken, fix it until it is.
My Blog