All the information about indexes for a table can be found using: ATagInfo()
Then all you have to do is step through the array and recreate all the indexes.
Einar
>Hi all,
>
>I've completed a automated backup process and would like to know how I can pack & reindex my database files via code. I want to ckeck the tags and indexes on my database tables and then drop and recreate them.
>
>Can this be done via code and how?
>
>Could you please assist!
>
>Thanking you.............
>
>Colin
Semper ubi sub ubi.