Re: rename a column

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/ Received on Thu Feb 08 2001 - 10:55:08 CST