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 delete column in a table ???

Re: How to delete column in a table ???

From: Winnie Liu <poohland_at_hotmail.com>
Date: Wed, 29 Jul 1998 20:08:35 -0700
Message-ID: <6ponrg$25e@dfw-ixnews10.ix.netcom.com> 





There is no way to delete a column in Oracle. You have to recreate a new one
as select * from the old one (except the unwanted column).



Winnie




Macrino wrote in message <35BEC259.1B7984B3_at_indosiar.com>...


>Can anyone help me how to delete unwanted column in a table ?


>




Received on Wed Jul 29 1998 - 22:08:35 CDT












Original text of this message













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