Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can I rename a column name?
On Fri, 30 Apr 1999 21:27:47 GMT, yong321_at_yahoo.com wrote:
>In Oracle 7, can I rename a column name, or I have to do it by creating a new
>table with the new column name (and drop the old table)?
There is no way to rename a column, so you do have to recreate the table. It's a pain, I know.
Jonathan Received on Fri Apr 30 1999 - 21:10:47 CDT