Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: delete col
thanks....ed
Thomas J. Kyte <tkyte_at_us.oracle.com> wrote in message
news:8fcc67$nlt$1_at_nnrp1.deja.com...
> In article <8fca9l$2ti$1_at_bob.news.rcn.net>,
> "ed zappulla" <zappullae_at_rcn.com> wrote:
> > Does anyone know how to remove a column from an ora db. 8.0.0.5 and
8.1.6?
> >
> >
>
> 8.1.5 and up:
>
> alter table T drop column C;
>
> before 8.1, you would:
>
> rename table T to X
> create view T as select <all but that column> from X;
> revoke <whatever> on x
> grant <whatever> on T
>
> --
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries
> http://osi.oracle.com/~tkyte/index.html
> --
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed May 10 2000 - 00:00:00 CDT