Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete column of table in Oracle 8.1.7
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 - 18:37:57 CDT