Re: newbie question on sql

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 15 Apr 2001 12:52:26 +0200
Message-ID: <tdiv7g2953ppec@beta-news.demon.nl>

"webbug" <NOSPAMbandlover_at_hotmail.com> wrote in message news:20010415.181554.846811127.4449_at_localhost.localdomain...
> hello all,
> is it possible to rename a column of a table?
> if not, any other alternatives?
> thanks

It is not possible.
In 8i and beyond you can drop a column
Please refer to the alter table command in the sql reference manual for the exact syntax. IMO, databases still need to be designed, so you should try to do this only rarely.

Regards,

Sybrand Bakker, Oracle DBA Received on Sun Apr 15 2001 - 05:52:26 CDT