Re: Drop Column

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 04 Nov 1999 20:16:30 -0500
Message-ID: <1y8iOJTq3MyHkuMFqbNS51AfooWv@4ax.com>

A copy of this was sent to John Duran <d3plan_at_hotmail.com> (if that email address didn't require changing) On Thu, 04 Nov 1999 22:46:32 GMT, you 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
>

that works in Oracle8i release 8.1.

Before that, no drop column.

>Doesn't seem to work
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Nov 04 1999 - 19:16:30 CST