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.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.