Re: Drop Column from a Table

A copy of this was sent to gbergerpios_at_my-deja.com (if that email address didn't require changing) On Thu, 16 Dec 1999 19:21:23 GMT, you wrote:

>What is the command for dropping a column of a table?
>
>The ALTER TABLE command (in ORACLE8: The Complete Reference pg 996)
>shows
>
>ALTER TABLE ..
>...
>...
>DROP drop_clause
>
>but I can't seem to find the way to drop a column.
>Thanks,
>Gene Berger
>

its in Oracle8i release 8.1 (*not* 8.0)

alter table foo drop column bar;

>
>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 Dec 16 1999 - 15:59:18 CST