Re: how to drop a column?

From: mike <skyxx_at_263.net>
Date: Wed, 30 Aug 2000 13:27:07 +0800
Message-ID: <8oi5rv$29ut$1@news.cz.js.cn>

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