Thanks! it is a good idea to do everything offline during midnight!

>>I can use "alter table add column" to add a new column at the end of the table column definition. Is there a way to add the new column at a particular position, such as before or after a certain existing column?
>>
>>Thanks!
>
>I think, not with ALTER TABLE - apparently, the column position is deemed irrelevant.
>
>You might, however, do a CREATE TABLE and then use APPEND FROM, for example. See also COPY STRUCTURE EXTENDED.
>
>Personally, in Bata/Bolivia I make all database changes manually, in an empty database (i.e., none of the tables has records), and then I run a process, at midnight, that basically does an APPEND FROM for each table, into the new (empty) structure.
javascript:MessageSubmit()
[Save this message so it will appear for other members immediately]