Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to drop a column?

Re: how to drop a column?

From: Dirk P.C. Wendt <dpcw_at_xodox.org>
Date: Wed, 30 Aug 2000 07:02:34 +0200
Message-ID: <8oi4od$b013d$1@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:02:34 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US