Re: Drop Column with Oracle 7.3

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 Wed Aug 26 1998 - 06:49:47 CDT