Re: Reorder columns?
- From: "Jim Kennedy" <kennedy-downwithspammersfamily@xxxxxxxxx>
- Date: Mon, 19 Dec 2005 07:43:28 -0800
"harry" <a@xxxxxxx> wrote in message
news:_Szpf.11612$iz3.6519@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> thanks for the replies, think I'll just leave it as it is, doesn't cause a
> problem, just would have been neater that's all!
>
>
> <sybrandb@xxxxxxxxx> wrote in message
> news:1135003961.834319.140660@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > There is not.
> > Usually RDBMSes are being *designed* instead of hacked together, and
> > adding a column occurs seldomly.
> > You could of course also
> > -create a view on this table with the correct column order
> > -dump this (and possibly other ) table and start all over again, and
> > now do things *properly*
> >
> > The last option is probably the best in your case.
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
> >
>
>
You can also just ask for the columns in whatever order you want. The
actual order in the table is irrelevant.
Jim
.
- References:
- Reorder columns?
- From: harry
- Re: Reorder columns?
- From: sybrandb@xxxxxxxxx
- Re: Reorder columns?
- From: harry
- Reorder columns?
- Prev by Date: Re: Remove all tables for user with one SQl statement?
- Next by Date: Re: Reorder columns?
- Previous by thread: Re: Reorder columns?
- Next by thread: Re: Reorder columns?
- Index(es):
Relevant Pages
|
