Here's the scenario: You have an application that will be distributed. It has a database with tables used by the screens and reports (of course). After distribution, you decide to add fields to a table. What is the best approach to doing this effectively?

One way: MODIFY mydbc
REMOVE TABLe one2change
USE one2change
?? how do you add a field without the database designer
other code
ADD TABLE one2change

Or do you have to send a blank file and append the data to it, remove old table from dbc, replace with new???

How do the pros do it??