Re: Drop Column with Oracle 7.3

From: <jtesta_at_my-dejanews.com>
Date: Wed, 26 Aug 1998 15:09:08 GMT
Message-ID: <6s18ek$bql$1@nnrp1.dejanews.com>

AND rebuild all indexes, foreign keys, constraints, etc. Its is a bit more than just copying the data.

In article <35e3f521.15980044_at_news.telecom.ptt.nl>, secret_at_mail.address (Marty_D) wrote:
> 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;
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 26 1998 - 10:09:08 CDT