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.

• Next in forum: Re: Error message on using union statement with order by using reserved words
• Prev in forum: Re: get some rows into one column
• Thread view: Add a coulm in a table, after a specific column

[Reply to this message]