Re: Column Order in Table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Paul Pedersen (no-reply_at_swen.com)
Date: 11/26/04 

Date: Fri, 26 Nov 2004 13:10:21 -0800

FWIW, I was interested too, just on general principle. I know it doesn't
"matter" all that much, but I want to know how to do whatever I want with
the data.

I knew it was possible to do it in the Enterprise Manager, but I didn't know
it was dropping and recreating the table. Thanks.

"raydan" <rdanjou@savantsoftNOSPAM.com> wrote in message
news:OFpVmvx0EHA.3500@TK2MSFTNGP09.phx.gbl...
> In addition to what Aaron said...
>
> From BOL
> System tables should not be altered directly by any user.
>
> Don't do this, ever.
> I tried this as an experiment in a test database once and screwed up
> royally
> the database.
> Good thing it was a test database as I had no other choice then to delete
> it.
>
> There is no system sp/func for this and there probably never will be as
> the
> order of the columns is not important. You can reorder columns in
> Enterprise
> Manager but behind the scenes it drops and recreates the table.
>
> "Leila" <Leilas@hotpop.com> wrote in message
> news:eZRp6Ox0EHA.3616@TK2MSFTNGP11.phx.gbl...
>> Hi,
>> I know that physical order of a column is not important in tables but I
> like
>> to know if it is possible to force column order when I alter a table to
> add
>> column or change the order later.
>> It seems that the orders are stored in syscolumns table but I think there
>> should be a system sp/func to alter that.
>> Thanks,
>> Leila
>>
>>
>
>

Relevant Pages

  • Re: Column Order in Table
    ... I knew it was possible to do it in the Enterprise Manager, ... it was dropping and recreating the table. ... > Good thing it was a test database as I had no other choice then to delete ... > There is no system sp/func for this and there probably never will be as ...
    (microsoft.public.sqlserver.server)
  • Re: Column Order in Table
    ... In Enterprise manager open a table in design mode ... > I knew it was possible to do it in the Enterprise Manager, ... > it was dropping and recreating the table. ... >> I tried this as an experiment in a test database once and screwed up ...
    (microsoft.public.sqlserver.server)
  • Re: Column Order in Table
    ... In Enterprise manager open a table in design mode ... > I knew it was possible to do it in the Enterprise Manager, ... > it was dropping and recreating the table. ... >> I tried this as an experiment in a test database once and screwed up ...
    (microsoft.public.sqlserver.programming)
  • Re: Column Order in Table
    ... In addition to what Aaron said... ... I tried this as an experiment in a test database once and screwed up royally ... There is no system sp/func for this and there probably never will be as the ... > should be a system sp/func to alter that. ...
    (microsoft.public.sqlserver.programming)
  • Re: Column Order in Table
    ... In addition to what Aaron said... ... I tried this as an experiment in a test database once and screwed up royally ... There is no system sp/func for this and there probably never will be as the ... > should be a system sp/func to alter that. ...
    (microsoft.public.sqlserver.server)