Re: Dropping a column in Oracle

From: Henk Van Heghe <henk.vanheghe_at_ping.be>
Date: Mon, 27 Apr 1998 19:22:24 GMT
Message-ID: <6i2lqp$ite$1@news3.Belgium.EU.net>

scottcr_at_widget.seas.upenn.edu (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.

create table new(a, b)
as select a, b
from old
rename new to old
!You don't take constraints along !

>- 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 Mon Apr 27 1998 - 14:22:24 CDT