> I want to modify the table structure in a database for my customer, my > customer has input many data already, and they have not VFP development > environment! I know I can modify the structure manually in my office, but > they have to stop their working for one day, so I want to write a program > to do the modification, which way is better ? I tried the ALTER command, > but I cannot insert field in the proper order ! Any help is appreciate !!! I have a small .EXE that is a Command-Window simulator, for instances just like this. This is written in 2.6 and also works in 3.x and 5.x. If I get a chance, I'll post it to the UT files list. /Paul