I think you have to give the index command separately. It seems there are commands for RI, which will implicitly create indices, but no specific indexing commands, in the SQL which VFP supports.
>Hi - maybe I am missing something but is there no way to create a regular index with a CREATE TABLE command?
>
>At moment I am doing this...
>
>
>CREATE TABLE test NAME test (id I, testfield C(60), UNIQUE id TAG iID)
>INDEX ON testfield TAG iTestField
>
>
>Thanks
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)