Create the new table using the CREATE TABLE command, with the correct ordering of fields. Then APPEND FROM the original table.

>Dear Sir,
>
>I created a table, entitled table1, with table designer.
>The fields are as follows
>
>

>a	n(1)
>b	c(1)
>c	n(2)
>d	n(1)
>

>
>I want to change field order programatically as follows
>
>

>b	c(1)
>a	n(1)
>d	n(1)
>c	n(2)
>

>
>Is it possible to chage field order programatically,
>if then please help me.
>
>Thanks in advance