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

Thx Yosi..

We have 7.3 so it answers my question..

Bruno Paquette

Yosi Greenfield <ygreenfield_at_compuserve.com> wrote in message news:381F1676.842F6923_at_compuserve.com...
> 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 - 14:16:27 CST