Re: Change/delete column name without drop table?
Date: Sun, 07 Feb 1999 18:44:53 GMT
Message-ID: <79kmv4$a6k$1_at_nnrp1.dejanews.com>
Albert,
In one of the newsgroups it was mentioned that this feature is available in Oracle 8i. But till then you cannot drop or rename a column without dropping the table. Maybe you can use a work around. Why don't you create a view with the new column name ?
Denny
In article <36BDC666.B0EC96D_at_gte.net>,
Albert Zhu <lzhu_at_gte.net> wrote:
>
> Hi,
>
> Hi,
>
> I am looking for a way in sqlplus to change/delete a column name. The
> ALTER TABLE seems can not do that. And I can not drop the table
> because it is tied to too many other tables.
>
> Any help is very appreciated.
>
> Albert
>
>
Denny Koovakattu
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Feb 07 1999 - 19:44:53 CET