>Does anyone know a one-line command to add a field to an existing table?
>
>I would rather not create another table with the extra field and copy the data over.

Dan,
In 2.6, the quickest way would be to "SELECT *, + newfield from tablename" to end up with a table with the new field. 2.X doesn't support ALTER TABLE, a VF command that adds, edits or removes fields, as John pointed out in his last message. :)
Brad