Re: Drop Column from a Table

Ohhh ... thanks Thomas!!!

In article <15oi5s8i68rb4tjrchbkk27ra1qv1b7b3r_at_4ax.com>,   tkyte_at_us.oracle.com wrote:
> 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
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 17 1999 - 14:29:13 CST