Re: Drop Column

From David P,

Hi John,

             (prepare to be ?frustrated?) - unless you are running Oracle 8i you can't drop a column. If you are using Oracle 8i, sorry but I can't help - I only have access to the 8.0.5. Enterprise Edition documentation (not the 8.1.5. series i.e. Oracle 8i)

John Duran wrote:

> What is the syntax for dropping a Column from a table.
>
> the ref mentions add columns, and modifing columns.
>
> the standard SQL command:
>
> ALTER TABLE MYTABLE
> DROP MYCOLUMN
>
> Doesn't seem to work
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.