Re: drop column?

This is 8.1.5 command, drop is not supported in 8.*0*.5. He needs to use conventional methods
- create a view without the column
or
create table ..._new as select ... from <old_table> drop <old table>
rename <..._new> to <old_table>

Hth,

Sybrand Bakker, Oracle DBA

"Fabio Franco" <fabio.franco_at_rsisistemi.it> wrote in message news:8mrdm1$3tc8$1_at_stargate1.inet.it...
> The command is:
>
> alter table <table_name>
> drop column <column-name>;
>
> Ed Zappulla <zappullae_at_rcn.com> wrote in message
> 8mq715$dhl$1_at_bob.news.rcn.net...
> > does anyone know how to drop a column in ora 8.0.0.5?
> >
> >
> >
>
>
Received on Wed Aug 09 2000 - 00:00:00 CDT