>>>No directly from VB (INDEX ON is unsupported command for OleDb), but you could create a StoredProcedure in DBC and call it (not tested).
>>
>>I will probably use the route of the CommandText by issuing a series of commands with the ExecuteNonQuery().
>
>Hi Michel,
>
>You can use EXECSCRIPT() function, VFPOLEDB supports it.
>
>Thanks,
>Aleksey.
Cool. Never thought of that and was instead keeping templates of original tables with indexes and no data in them (metadata - I'd keep anyway as a data dictionary).
Cetin