Re: Dropping constraints ??

From: Edward L Dansker <edansker_at_us.oracle.com>
Date: 1995/06/22
Message-ID: <3sbqkb$27o_at_inet-nntp-gw-1.us.oracle.com>#1/1


jalford_at_immcms1.redstone.army.mil (huckleberry) writes:

>hello all,
>
> In my haste to create some tables, I put a REFERENCES constraint on a field
>and did not give the constraint a name, now I need to change the data.
>I have tried unsuccessly to disable this nameless constraint. Is there no way
>to disable this constraint ??
>
>constraint:
>
> loan_number varchar2(12)
> REFERENCES LOAN(loan_number)
> ON DELETE CASCADE,
>
>any help will be appreciated !! Thanks !
>
> - huckleberry

Why don't you query the data dictionary table USER_CONSTRAINTS to find the name that Oracle assigned to the constraint as a default and then drop it?

Ed Received on Thu Jun 22 1995 - 00:00:00 CEST

Original text of this message