Re: rename a column

robertboyle_at_my-deja.com wrote:

> In article <95ui8l$uue$1_at_nnrp1.deja.com>,
> rannerde_at_my-deja.com wrote:
> > Dear NG!
> > How do I rename an existing column of a table with Oracle SQL?
> >
> > Thank you,
> > Gerfried Ranner
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
> You can't rename a column. Try creating a temp table with your data
> and then dropping and recreating your table:
>
> CREATE TABLE temptable AS
> SELECT * FROM existingtable;
>
> DROP TABLE exisitingtable;
>
> CREATE TABLE (new definitions and column names);
>
> INSERT INTO existingtable
> SELECT * FROM temptable;
>
> DROP TABLE temptable;
>
> COMMIT;
>
> Sent via Deja.com
> http://www.deja.com/

Or create a view. Depends on how many apps would need to be changed if you rename the actual column. Received on Thu Feb 08 2001 - 12:33:06 CST