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 -> Re: Can I rename a column name?

Re: Can I rename a column name?

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sat, 01 May 1999 02:10:47 GMT
Message-ID: <373156ec.8666848@netnews.worldnet.att.net>


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

Original text of this message

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