Re: how to drop a column?

Hi, Dirk

You are right but IMHO not correct.

You could try command
CREATE TABLE TMP(...) AS SELECT ...
don't forget to eliminate the column and afterwards drop original table and rename TMP.

Or store appropriate table columns in text file and use SQL*Loader.

Yes you have to be very careful because of a routine around constraints, triggers etc. but it's still possible.

• Original Message ----- From: Dirk P.C. Wendt <dpcw_at_xodox.org> Newsgroups: comp.databases.oracle.server Sent: Wednesday, August 30, 2000 9:02 AM Subject: Re: how to drop a column?

> Hello,
>
> "mike" <skyxx_at_263.net> schrieb:
> > i am beginer of oracle.i created a table ,now i must drop a column of
> > it,how can i do?
>
> that's not possible with Oracle smaller than version 8.1.5 I think:
>
> ALTER TABLE "Tablename" SET UNUSED ("Columnname") CASCADE CONSTRAINTS;
>
>
> Ciao, Dirk.
>
>
>
Received on Wed Aug 30 2000 - 09:50:18 CDT