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.