Re: How to remove a non-used column from an existing table

DROP COLUMN only works in 8i and up.

Sorry...

Bruno Paquette wrote:

> Thx for replying but I still get the same message..
>
> ALTER TABLE mytable DROP COLUMN mycolumn CASCADE CONSTRAINTS
> *
> ERROR at line 1:
> ORA-00905: missing keyword
>
> There is a keyword missing but I can't find what keyword is missing..
>
> Thx anyways..
>
> Bruno Paquette
>
> Wim Valgaeren <valgaeren_at_softhome.net> wrote in message
> news:7vn0ug$crp$1_at_naxos.belnet.be...
> > ALTER TABLE mytable DROP COLUMN mycolumn CASCADE CONSTRAINTS
> >
> > This should work, I used this last week.
> >
> > Greetings,
> > Wim Valgaeren
> >
> > Bruno Paquette <bpaquette_at_airtransat.com> wrote in message
> > news:lUCT3.1976$2K1.56453_at_weber.videotron.net...
> > > Hi all,
> > >
> > > I don't know if I can do it but I'd like to remove a column from an
> > existing
> > > table but I don't find the syntax anywhere.
> > > I tried
> > >
> > > ALTER TABLE mytable DROP COLUMN mycolumn
> > >
> > > but I receive this message :
> > > ERROR at line 1:
> > > ORA-00905: missing keyword
> > >
> > > Can I remove a column from an existing table or if I have to recreate
> the
> > > table without this column ?
> > >
> > > Thx,
> > >
> > > Bruno Paquette
> > >
> > >
> > >
> >
> >
Received on Tue Nov 02 1999 - 10:51:02 CST