Re: Dropping a column in Oracle

From: <joseph_testa_at_aep.com>
Date: Fri, 01 May 1998 11:38:08 -0600
Message-ID: <6ictph$q0u$1@nnrp1.dejanews.com>

Yes you would have to add all the constraints, save yourself some time, go to my web page http://www.oracle-dba.com and go to the scripts link, get my drop column package, it does it all for you, the PK, FK, column constraints, indexes.

joe
http://www.oracle-dba.com

In article <35485FEE.ABA74A2_at_materna.de>#1/1, Frank Goebel <Frank.Goebel_at_materna.de> wrote:
>
>
> Henk Van Heghe wrote:
>
> > 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 !
> >
>
> But what about the constraints after? Must I add constraints again?
>
> Best regards
> Frank
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 01 1998 - 12:38:08 CDT