Dropping constraints ??

From: huckleberry <jalford_at_immcms1.redstone.army.mil>
Date: 1995/07/06
Message-ID: <jalford.220.005ACCA5_at_immcms1.redstone.army.mil>#1/1

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

Received on Thu Jul 06 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Thomas J Kyte: "Re: Refering to tables outside your schema - HELP!!!"
Previous message: David Jones: "test"
Next in thread: Jozef Starosta: "Re: Dropping constraints ??"
Reply: Jozef Starosta: "Re: Dropping constraints ??"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message