Re: Drop Column

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