look at ALTER TABLE in the help

>I have about 100 copies of an app I need to add new fields to some tables in each app.
>
>Can I add a new field, specifying its name, type etc to a table via some code without having to go into the table structure and doing it manually on each table?
>
>Thank you!