>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)