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 column of table in Oracle 8.1.7

Re: Delete column of table in Oracle 8.1.7

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Thu, 18 Apr 2002 23:37:57 GMT
Message-ID: <3CBF58CB.D3320F93@exesolutions.com>


Yes. But before you can:

ALTER TABLE table_name DROP COLUMN column_name;

You must:

ALTER TABLE table_name SET UNUSED column_name;

It is a 2 step process.

mark it as inactive.

Daniel Morgan

Franz-Josef Vorspohl wrote:

> Hi,
>
> it is possible to delete a column in Oracle 8.1.7 without create a new
> table?
>
> like this:
>
> ALTER TABLE tab DROP COLUMN col;
>
> Regards
>
> Franz-Josef
Received on Thu Apr 18 2002 - 18:37:57 CDT

Original text of this message

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