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

From: Bruno Paquette <bpaquette_at_airtransat.com>
Date: Tue, 2 Nov 1999 10:54:39 -0500
Message-ID: <dRDT3.2021$2K1.57243@weber.videotron.net>

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 - 09:54:39 CST