How to insert a new field on a designated position in a existing table???

[A . Beermann]

Hello !

I want to insert a new field into an existing table after/before an
existing field and i don't know how to code?!

alter table xyz add column newcolumn position = after field xxx      ???
                                         position = 4  ???

Is there a way to do this ???? If not, what is the easiest workaround
????

Any help welcomed
Albert
                    '''''
                  ''''''''' 
                    (0 0) 
 +---------oOO-------(_)-------------------+ 
 | Tel: 0541/5841-868                      | 
 | Fax: 0541/5841-869                      | 
 | Mail: mailto:[EMAIL PROTECTED]  |  
 | Internet:  http://www.piepenbrock.de    |
 +-------------------------------oOO-------+ 
                   |__|__| 
                    || || 
                   ooO Ooo