Re: URGENT!!! How can I drop a column???

Hi

In Oracle 8.1.5 you can drop a column by command: ALTER TABLE xxx DROP COLUMN yyy
In Oracle versions 8.0 and older, you can't drop a column, without recreating the table.

rgdrs Kari

(Mr.) Kari Pannila
Oracle DBA (OCP)
TietoEnator Corp - Telecom

Delete X to get a correct mail address ( X is only for the SPAMMERS ).

Steve A wrote:

> But nobody has actually answered the question.
>
> steve
>
> Billy Verreynne <vslabs_at_onwe.co.za> wrote:
>
> > Lesley wrote in message ...
> > >Wow, you are awfully bitter aren't you.
> > >I think they were just trying to help.
> >
> >
> > Suggesting the use of VB6 to drop a column in Oracle...? Well such a
> > suggestion IMHO deserved a sarcastic reply.
Received on Fri Mar 31 2000 - 00:00:00 CST