OraFAQ Forum: Server Administration » How do you change the position of a Column ?

Home » RDBMS Server » Server Administration » How do you change the position of a Column ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How do you change the position of a Column ? [message #371579]

Thu, 09 November 2000 08:30

Usheer Sing
Messages: 1
Registered: November 2000

Junior Member

Hi.

I would like to know if it is possible to change the position of a column in a table without dropping and re-creating the table ?

Thank you
Usheer

Report message to a moderator

Re: How do you change the position of a Column ? [message #371580 is a reply to message #371579]

Thu, 09 November 2000 09:51

Babu Paul
Messages: 38
Registered: November 2000

Member

Hi!
Good question! But I don't think there is any alter option to do this, unless we create another table with the same structure with columns repositioned and rename this to the original one.
I have my own doubts like where is this really needed. We have the option of selecting columns. And it really makes sense to drop a column from a table. But I am really keen to know where does this repositioning required.

Cheers
Babu

Report message to a moderator

Previous Topic:	Please help!!! MTS/COM+ Trouble
Next Topic:	SQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 03 10:27:48 CDT 2024