General information
Category:
Coding, syntax & commands
Title:
Automate adding field to an existing table
Environment versions
Network:
Windows 2003 Server
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? Thanks.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only