Re: Dropping a column in Oracle

From: Kevin P. Fleming <kfleming_at_access-laserpress.com>
Date: Thu, 16 Apr 1998 19:21:20 -0700
Message-ID: <3536BCA0.DF8707FB@access-laserpress.com>

If you can't drop the table temporarily, it can't be done. There is no way in Oracle to drop a column except to recreate the table, which requires (at a minimum) dropping and recreating any constraints/indexes associated with that table.

If you can't drop the table, set the column to allow NULLs, set all existing rows to have NULL in that column, and live with it...

Scott Mad Dog Raven wrote:
>
> Does anyone know how to drop a single column from a table in Oracle 7? The
> table has constraints to other tables and cannot be dropped.
>
> - Scott
>
> --
>
> ________________________________________________
> Scott "Mad Dog" Raven
> CSE '99
> Finger me to find out what I do.
>
> scottcr_at_seas.upenn.edu
> http://www.seas.upenn.edu/~scottcr
> (215) 382-2204
>
> No blood, no foul.
Received on Thu Apr 16 1998 - 21:21:20 CDT