>I see. "alter table tablename add column columnname d".
Yes, that is the command.
However, what I do to update the database on the production server (this would be similar on a client site) is to have a copy of the database with zero records on all tables; make any changes in this empty database; and then do an APPEND FROM for all tables. This will take care of most changes to the database structure, without having to write a program every time.
Note that if you have referential integrity, you have to copy the parent table before the child table.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)