Moving rows in a table

[Logician]

When I execute;

select * from alphabet;

I get the rows:

| A | B | D | C |

Is it possible to move the column "D" over, so I get:

| A | B | C | D |

?

[trq]

I assume you mean fileds, not rows. Don't use SELECT *, specify what fields you want and you will get them in the order you have asked for.

[Logician]

Wow, I meant columns. Sorry about that confusing post. I have been stressing due to crossing the line over to a state of development nightmare. I make allot of mistakes when I stress.

 

... so when I execute:

select * from alphabet;

instead of seing:

| A | B | D | C |

... I want to see:

| A | B | C | D |

[trq]

See my previous reply.

[The Little Guy]

alter table
yourtablename
change col4 col4 varchar(15)
after col2

[Logician]

Thanks, The Little Guy. That worked perfectly.