Add a coulm in a table, after a specific column

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.


.

Relevant Pages

  • Add a coulm in a table, after a specific column
    ... I know that in a relational database the order of the columns in a table ... simple ALTER TABLE instruction. ... Is there a stored procedure that can do this? ...
    (microsoft.public.sqlserver)
  • Re: ALTER design (Was: Code problems with Perform Thru Exit causes fall through)
    ... My first experience with the ALTER verb was our shop standards when I ... British Computers' where it describes programming for mercury delay ... So every instruction specified the ...
    (comp.lang.cobol)
  • Re: GO TO HELL.
    ... I am less glad the ALTER heavy ... DOS COBOL D compiler and the 16K partition limitation. ... the memory was much longer than the instruction execution time. ...
    (comp.lang.cobol)
  • Re: Help with Update Query
    ... May I ask why this is ALTER ... As for the Update statement in the stored procedure, ... load the tables with sample data, in addition to all the Transact-SQL ... DDL, INSERTS, and T-SQL here and I'll take a look at it. ...
    (microsoft.public.access.queries)
  • Re: Create a read only stored procedure
    ... Here is the code to prove that the ALTER can still be used to change the ... create proc sp_that_users_cant_change ... >> You can use the following undocumented method of making to create a system>> stored procedure. ... >>> user edit it in Enterprise Manger like system's procedures. ...
    (microsoft.public.sqlserver.programming)