Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to drop a column?
Dear dirk:
Thank u very much!
But it still don't work !
the error msg is "illegal alter table option"
"Dirk P.C. Wendt" <dpcw_at_xodox.org> wrote in message
news:8oi4od$b013d$1_at_ID-25048.news.cis.dfn.de...
> Hello,
>
> "mike" <skyxx_at_263.net> schrieb:
> > i am beginer of oracle.i created a table ,now i must drop a column of
> > it,how can i do?
>
> that's not possible with Oracle smaller than version 8.1.5 I think:
>
> ALTER TABLE "Tablename" SET UNUSED ("Columnname") CASCADE CONSTRAINTS;
>
>
> Ciao, Dirk.
>
>
>
Received on Wed Aug 30 2000 - 00:27:07 CDT