Re: Drop Column with Oracle 7.3

From: Gitte Tøgersen <gittetogersen_at_usa.net>
Date: Thu, 27 Aug 1998 08:22:05 +0200
Message-ID: <6s2u1a$4h1$1@dalen.get2net.dk>

Hi,

As I said, 'You can't just drop a column in a table', as the way You can insert a new column - You have to create a new table....

Kind regards

Gitte Tøgersen
Denmark
E-mail : gittetogersen_at_usa.net

Marty_D skrev i meddelelsen <35e3f521.15980044_at_news.telecom.ptt.nl>...
>On Wed, 26 Aug 1998 12:46:47 +0200, "Gitte Tøgersen"
><gittetogersen_at_usa.net> wrote:
>
>>Hi Olivier !
>>
>>You can't drop a table column, the only way is to create
>>a new table, without the column You want out.
>>
>
>Like this:
>
>Create table EMP2
>as
> select A,B,D <--- excluding column you not want here
> from EMP
>;
>
>Drop table emp;
>
>rename EMP@ to EMP;
Received on Thu Aug 27 1998 - 01:22:05 CDT