Hi, Everybody! 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 !!! Catherina of AS SOTA Co.