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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Deleting a column from a table ?

Re: Deleting a column from a table ?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 10 Apr 2001 09:05:02 +0200
Message-ID: <9aubau$h7n$1@s1.read.news.oleane.net>

"Hans Rytter" <hry_at_post7.tele.dk> a écrit dans le message news: 3AD2A640.367BC506_at_post7.tele.dk...
> Hi.
> Is it possible to delete a column from a table, alternatively is it
> possible to alter the name of a column ???
>
> My db is a ver. 7.3 Oracle.
>
> /Hans.
>

In Oracle 7.3, no.

With version 8i, you can set a column as unused or drop it but you can't rename it.

--
Regards
Michel
Received on Tue Apr 10 2001 - 02:05:02 CDT

Original text of this message

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