Re: how do i drop a column?

From: Chris Hamilton <ToneCzar_at_erols.com>
Date: Sat, 20 Mar 1999 03:10:14 GMT
Message-ID: <36f31175.6959765@news.erols.com>

On Fri, 19 Mar 1999 18:42:51 -0500, Misha Nicholas <xenome_at_earthling.net> wrote:

>This is a way to accomplish what you want:
>
>RENAME the_table TO the_table_temp;
>CREATE TABLE the_table AS
>SELECT field1, field2...fieldn -- exclude field you don't want
>FROM the_table_temp;
>DROP TABLE the_table_temp;
>
>If anyone knows a way to actually drop a column from a table, please let
>me know.

It can be done with Oracle 8i with a single command.

Chris

---

Chris Hamilton -- toneczar_at_erols.com
Oracle DBA -- Wall Street Sports
http://www.wallstreetsports.com/ Received on Fri Mar 19 1999 - 21:10:14 CST