>Well, the tables in question have a whole shed-load of (sometimes compound) indexes. Is there a way of preserving their definitions so that I don't have to go into the table builder and manually and laboriously create the indexes all over from scratch? - Especially if this should happen more than once, and to several tables, as has just happened to me!
I keep a whole folder full of indexing PRGs, named by the tables they're used for. They all look very similar, about like this:
SET EXCL ON
USE? (get the table you want)
DELETE TAG ALL
INDEX ON field1 TAG etc.
INDEX ON field2 TAG etc.
where "fields" can be complex/compound code
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
