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

From: Wim Valgaeren <valgaeren_at_softhome.net>
Date: Tue, 2 Nov 1999 16:52:10 -0000
Message-ID: <7vn0ug$crp$1@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:52:10 CST