>I have an application where we keep a separate database for each client and we now have over 1,000 separate databases. Each database is identical with the same set of tables, views, etc. I need to add a new field to one of the tables in the database. Is there a way to automate just adding a new field to a table without removing the current table, adding the new table and appending the old data back in?

Did you try

ALTER TABLE mytable ADD COLUMN NewColumn C(20)