Non Zeos ALTER TABLE question

[cariad]

Hello,

I searched through the SQL reference doc, various forums, ... but did not find any authoritative answer regarding this question :

When you change a table structure to add a column(s) using ALTER TABLE ADD..., are the column(s) *always* added at the end of the table structure ? (I know you can reposition them if needed).

Any ideas ?

[Bottleneck]

Hello cariad,

this is one of my SQL scipts to add a field and change the position of this field.


SET NAMES ISO8859_1;

alter Table ICenter
ADD IC_Kenn VARCHAR(24) CHARACTER SET ISO8859_1 DEFAULT '?' NOT NULL;

COMMIT WORK;

Alter Table ICenter
alter IC_Kenn POSITION 5;

Commit work;



Greetings
Peter