Re: Delete column of table in Oracle 8.1.7

From: Alex Ivascu <alexdivascu_at_yahoo.com>
Date: Fri, 19 Apr 2002 01:13:02 GMT
Message-ID: <yaKv8.38076$071.11651475@typhoon1.we.ipsvc.net>

You don't 'have' to set it as UNUSED, right DM?

Alex Ivascu

"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:13:02 CDT