Re: Delete column of table in Oracle 8.1.7

From: santosh sharma <no-one_at_yahoo.com>
Date: Thu, 18 Apr 2002 18:04:43 -0700
Message-ID: <a9nqkd$4ut1g$1@ID-84096.news.dfncis.de>

There are two ways to drop a column:
alter table a drop column b;
This is one step process.

second method is :
alter table a set unused b;
alter table a drop unused columns;

santosh

"Daniel Morgan" <damorgan_at_exesolutions.com> wrote in message news:3CBF58CB.D3320F93_at_exesolutions.com...
> Yes. But before you can:
>
> ALTER TABLE table_name DROP COLUMN column_name;
>
> You must:
>
> ALTER TABLE table_name SET UNUSED column_name;
>
> It is a 2 step process.
>
> mark it as inactive.
>
> Daniel Morgan
>
>
>
> Franz-Josef Vorspohl wrote:
>
> > Hi,
> >
> > it is possible to delete a column in Oracle 8.1.7 without create a new
> > table?
> >
> > like this:
> >
> > ALTER TABLE tab DROP COLUMN col;
> >
> > Regards
> >
> > Franz-Josef
>
Received on Thu Apr 18 2002 - 20:04:43 CDT