Thank's a lot for your andswer.
and i'm sorry for the delay of my reply

Rock

>Hi Rock.
>
>>Do you know if we can specify the possition of a column added with the alter table command instead of the last possition.
>
>As Nadya pointed out, the answer is no when using ALTER TABLE. However, Stonefield Database Toolkit (SDT) can handle this and a lot of other similar issues for you. For more information on SDT, see Stonefield's Web site.
>
>Doug