See
ALTER TABLE - SQL Command in the help.
>
>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?
>
--sb--