Vicki,
Try the ALTER TABLE command.
Mark
>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??
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.