We are partial to the Stonefield Database Toolkit. Doug provides a very robust set of methods for working with table and databases both in development and more importantly in the field. In this case if you had the DBCX/Stonefield metadata extensions installed a call to oMetaMgr.SDT.needsupdate() and update(all) would upgrade the tables in the field without a developemen environment or conversion process. Check out their site/cost is minimal given the functionality.
IMO
Gary

>> 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