Re: How do you drop a column in Oracle 8?

From: Pavel Polcar <pavel.polcar_at_berit.cz>
Date: Wed, 30 Sep 1998 16:37:54 +0200
Message-ID: <6utg20$5dk$1@cbu.pvtnet.cz>

Hi,
it will be possible in Oracle 8i, now you have to create a new table without the column, copy the data and
drop the original table (or create a view over the original table selecting all but the unwanted column).

Regards,

Pavel Polcar
ffinstad_at_globalsight.com wrote in message <6ursht$hkv$1_at_nnrp1.dejanews.com>...
>How do you drop a column in Oracle 8?
>
>I'm using the sql call:
>
>ALTER TABLE mytable DROP mycolumn;
>
>I get the error message:
>
>ORA-00905: missing keyword before mycolumn.
>
>Any ideas? This same sql worked in for me in other databases.
>
>Any help is appreciated.
>
>Thanks
>
>--
>Franco Finstad
>Web Developer
>Global Sight Corp.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Wed Sep 30 1998 - 09:37:54 CDT