Hi all,

I'm adding a routine to my new VFP6 system that will import data from the old FPD2.5 system. But I need to add a few new fields to some of the tables in the new system, and would also like to change the names of others. For example:

Old table:
Field1
Field2
FieldA

I want the new table to be:
Field1
Field2
Field3
Field4

(renaming FieldA to Field3 and adding new field Field4)

Is there a way to add fields to tables programmatically? How about renaming fields?

Thanks very much!

John