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

From: John Durst <jdurst_at_sky.net>
Date: Tue, 29 Sep 1998 22:51:46 -0500
Message-ID: <3611AAD1.837E59D4@sky.net>

Q: How do you drop a column in Oracle 8? A: Wait until Oracle8i.

ffinstad_at_globalsight.com wrote:

> 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 Tue Sep 29 1998 - 22:51:46 CDT