Hi Barbara ------

Hahaha!!! I just did the EXACT same thing the other day :)


>
>For a non-primary index, just use INDEX ON .... TAG ....
>
>If you really need to use the ALTER TABLE syntax, then run GENDBC on your DBC and look at the code generated. It will give you the exact syntax.
>
>Warning: Move the code generated by GENDBC very far away from your data tables. If you run it by accident (double-clicking in Explorer, for example) you will empty ALL your data tables!
>
>Barbara (who just finished restoring from a backup after double-clicking a GENDBC file)