Change column order in SQL Server 7

Is there an easy way to change the column order in a SQL Server 7.0 table. The column has data in it. The help mentions dragging and dropping in design table mode but I couldn' get it to work. If the solution is with Alter Table could you please provide an example.

Thank yoy, Tom.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I don't know, if SQL Server 7.0 has any easier method.  But in SQl Server 6.5 I would do it by copying data into temporary table and bringing it back. For eaxmple, to alter table A
select * INTO back_tableA from tableA
then do recreate original table with correct order and move data back.

You might not like this method, but it works.

Gustavo Perez BuenrostroCommented:
Could you be more specific?
boardtcAuthor Commented:
Ginde, thanks, you are right I was hoping for a more elegant solution. gpbuenrostro, I can't really put it any simpler than that, I am looking to reorder a column in an SQL Server 7.0 table which has existing data in the column. What don't you follow? Thanks. Tom.
Go to Design.
Mark the row you like to move.
then Just cut it out.
Go to the new place. Paste.
Works for me.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
boardtcAuthor Commented:
Great thanks, that was obvious, should have tried it. Note, there is no cut and paste options, do Shift+DEl and Shift+INS. Cheers, Tom.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.