Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> rename a column?
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