Re: Why does ORA not allow to rename and drop columns?

From: Klaus Zeuch <KZeuchnospam_at_hotmail.com>
Date: Fri, 20 Apr 2001 09:48:41 +0200
Message-ID: <9bota5$mt7$1@papyrus.erlm.siemens.de>

Reason: You are using an old version

In Oracle 8.1.x:

ALTER TABLE tablename SET UNUSED COLUMN columnname ALTER TABLE tablename DROP COLUMN columnname ALTER TABLE tablename ADD (columnname datatype) ALTER TABLE tablename MODIFY (columnname datatype)

Klaus

Lanying & Manfred Chen-Fischer <manfis_at_t-online.de> schrieb in im Newsbeitrag: 9bomc3$cr0$07$2_at_news.t-online.com...
> With the help of an ALTER statement, all the other database system have
the
> opportunity to create, alter and drop columns in a direct way without
> copying and renaming tricks.
>
> What is the reason for this stupid limitation?
>
>
>
Received on Fri Apr 20 2001 - 02:48:41 CDT