Create another table with a select...

select b,a,d,c from table1 into table table2

What is the reason you are needing the physical order of the fields changed?

>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