Re: how to drop a column?

"mike" <skyxx_at_263.net> wrote in message news:8oi5rv$29ut$1_at_news.cz.js.cn...
> Dear dirk:
> Thank u very much!
> But it still don't work !
> the error msg is "illegal alter table option"
>

Well, did you read his original message carefully, or what?

What version of Oracle do you have?

Anything earlier than 8.1.5, and the command he describes won't work. In which case your only option is to create a new table as a copy of the old one, drop the old one, then rename the new copy to be the same name as the old original.

Which is expensive, because no constraints are carried over the copy, nor are permissions, nor are any indexes. All will need to be redefined and recreated.

Regards
HJR
>
> "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 Sun Sep 03 2000 - 03:33:30 CDT