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: Delete a column

Re: Delete a column

From: Rachel Carmichael <rachel.carmichael_at_citicorp.com>
Date: 1998/04/06
Message-ID: <3528D1C5.96D7BE18@citicorp.com>#1/1

Short answer: no.

If you don't have any 3rd party product that will do this, the only way to do it is to create a second table by selecting only the columns you want from the original table, drop the original table, rename the second table to the original name, and recreate any grants, constraints, indexes etc

Rachel

Arie Zevenbergen wrote:

> Is there an easy way to delete a column from a table ?
>
> e-mail: aa.zevenbergen_at_consunet.nl
Received on Mon Apr 06 1998 - 00:00:00 CDT

Original text of this message

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