Re: field deletion

From: <ddf_dba_at_my-deja.com>
Date: 2000/06/06
Message-ID: <8hjbdg$99k$1@nnrp1.deja.com>#1/1

In article <8hj6ib$57e$1_at_nnrp1.deja.com>, christopher.lewis_at_ac.com wrote:
> Hi all, what is the syntax for removing a field (and any constraints)
> from a table during an alter table? Thanks!
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Christopher,

I'm sorry, but you cannot drop a column or a constraint from a table even with the alter table command. The only way to accomplish this is to re-create the table without the column or the constraint in the specification. You can disable constraints on a table but you cannot drop the constraint without dropping the table.

David Fitzjarrell
Oracle DBA

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jun 06 2000 - 00:00:00 CDT