Re: Dropping a column in Oracle

Hi Scott,

Why do you want to drop the column?

Why not just create a view that doesn't include it?

Why not do your select statements using column names instead of "*" ?

The reason I ask these questions is that, to the best of my knowledge, there isn't an easy way to do what you want -- drop a column. It is possible to drop your constraints, unload the data, temporarily drop the table, recreate it the way you want, reload it using SQL*Loader, and then reenable the constraints -- but it is a pain in the neck do so.

Regards

Jerry

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.

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_p3.net 	Opinions are mine not those of ICT Group