Re: Dropping a column in Oracle

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 Received on Thu Apr 30 1998 - 06:26:38 CDT