Re: Dropping a field from a table

From: Anton Dischner <dischner_at_klch.med.uni-muenchen.de>
Date: Fri, 21 May 1999 10:32:26 +0200
Message-ID: <210519991032267161%dischner@klch.med.uni-muenchen.de>

Hi,

There is no 8.3.
What you mean is 8.1.3 aka Oracle8i.
In 8.1.4b the following is possible:

alter table <table_name> drop column <column_name>;

alter table <table_name> set unused column <column_name>;

alter table <table_name> drop unused columns;

Kind regards,

Toni

In article <3732F96E.6F361436_at_india.hp.com>, G.H VITTAL <vittal_at_india.hp.com> wrote:

> In oracle 8.3 it is possible to delete a column i beleive. However if you
> are useing oracle 7.3 the only way you can delete a column is
>

... Received on Fri May 21 1999 - 03:32:26 CDT