Posted by D. on 10/31/07 13:29

I know that in a relational database the order of the columns in a table
usually is not important, but I need to know if it's possible to alter a
table adding a column in a specific position, so when I do "SELECT *
FROM..." I see the columns in the order I like (the most important columns
in first position).

I read the SQL Server 2005 manuals and it seems it's not possible with a
simple ALTER TABLE instruction.

Is there a stored procedure that can do this?

Thanks in advance,
D.

[Back to original message]