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

If you are using Oracle8i, you can drop a colum very easily. ALTER TABLE mytab DROP(column_element);

Otherwise, create a temporary table with the columns you want, drop the original one and use the sql copy command to create the original one.

teve A" <steve_at_micromark.com.cn> wrote in message news:1e8b666.1duh68sftflbgN%steve_at_micromark.com.cn...
> 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 Sun Apr 23 2000 - 00:00:00 CDT