Hi Terry,
I have a program called update.exe and below are some of the sample code I use to modify the database & Tables.

First Open the database you want to use.
open data "YOURDATABASENAME" EXCL

ALTER TABLE "TABLENAME" ADD NEWFIELDNAME L
CREATE TABLE 'LABELS.DBF' NAME 'LABELS' (LINE1TOP N(3, 0) NOT NULL, LINE2TOP N(3, 0) NOT NULL)

If Adding New Indices select the table and then use the index on command.

I have about 40 store using this program. All I do is send them the update.exe and they run it as an External process with the Update Version as a parameter.

Hope this helps you.

Regards,
Fred