Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> rename a column?

rename a column?

From: Tom La Porte <tlaporte_at_dreamworks.com>
Date: 1997/09/04
Message-ID: <340F5973.41C6@dreamworks.com>#1/1

Is there any way to rename a column, other than recreating the table?

The ALTER TABLE command allows you to change constraints and data types on a column, but doesn't seem to allow a name change.

It's not a crucial issue, but I couldn't find anything in my brief search of the Oracle docs. Just wondering if I missed something obvious.

Any suggestions are appreciated.

-- 
"If I could dot the 'i' in a Michigan     Thomas A. La Porte
 game and the good lord came to take me   DBA, Feature Animation 
 the next day ... at least I could        DreamWorks SKG
 die happy." - Beano Cook, ESPN           <tlaporte_at_anim.dreamworks.com>
Received on Thu Sep 04 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US