Hi!

Non of the database systems have SQL commands to create indexes. Indexes are internals of the database and are specific for each database system.

In VFP you can create regular indexes only using INDEX command. Seems in your program you require to store each index in the table, or store a set of INDEX commands that you write from memo to PRG file, compile by COMPILE command than run as a program.

In SQL server, for example, there are other commands and SP for indexes management. They, however, are not a standard SQL commands.

HTH.

>I like to store SQL create command to table field. So next time I can create it by
>
>mTableCreate = table.detail
>&mTableCreate
>
>I know how to creat the primary index key eg.
>
>CREATE TABLE salesman ;
> (SalesID c(6) PRIMARY KEY, ;
> SaleName C(20))
>
>
>But what is the command to create regular index?
>
>TIA.