Re: EASY? Drop a column in a table.

In article <ep3g6300004_at_novalink.com> bmay_at_novalink.com (Brett M May) writes:
> >
> > I'm somewhat new at this. I tried to drop the column APPL_ID in
> > a table called PERSON in Oracle 7. I tried:
> >
> > alter table PERSON drop (APPL_ID)
> >
> > but was told I was missing an expression.
> > I figure either this is very easy to do, or it can't be done.
> > HELP!
> > Anil Rhemtulla
> >
>
> Anil, I hate to be bearer of ill news and such, but you can't drop a
> column from a table in any version of oracle that I've seen. You can
> add a column to a table, or modify it by changing its length, but you
> can't drop it.
> Your only recourse is to drop the entire table and recreate it minus the
> offending column.

I wonder how many people would love to do this. I hate dropping tables and recreating them. Why can't you drop a column?

-- 
Neil Greene
benchMark Developments, Inc. [NeXT VAR]
2040 Regency Road, Suite C Lexington, KY 40503
Phone: 606-231-6599 / Fax: 606-254-4864