Re: Drop column package?

From: <kal121_at_yahoo.com>
Date: Fri, 17 Dec 1999 18:03:20 GMT
Message-ID: <83dtt5$2td$1@nnrp1.deja.com>

Oracle 8i allows column drops (but not previous versions):

ALTER TABLE my_table DROP COLUMN col1;
Make sure you have your COMPATIBLE parameter set to 8.1.0.

If you are not running 8i, you can simply recreate the table without the column, if you can afford the downtime.

In article <385A558D.F6C3E0BB_at_intrasoft.gr>, CC <kkons_at_intrasoft.gr> wrote:
> hi all,
>
> Does anyone know where can I find a package or a tool that can drop a
> column of a table?
> I already got one but it seems not to work.
> I 've heard about Hora-4 tool but I can't download it and it is only a
> trial version.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 17 1999 - 12:03:20 CST