Re: Dropping constraints ??

From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/06/22
Message-ID: <Pine.SUN.3.91.950622150647.15666D-100000_at_seatimes>#1/1

On Tue, 20 Jun 1995, huckleberry wrote:
> 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 ??

First, you can always drop and recreate the table <<grin>>.

However, you might want to look in USER_CONSTRAINTS first (do a describe). You should be able to identify the constraint as it will be a TYPE 'R' and you can see the reference information in USER_CONSTRAINTS. This same table will show you the name being used for that constraint. It will start of with SYS and have a bunch of numbers.

Good Luck.

Oh, you can use that system developed name to drop only that constraint.

+----------------------------------------------------+
| Steve Butler          Voice:  206-464-2998         |
| The Seattle Times       Fax:  206-382-8898         |
| PO Box 70          Internet:  sbut-is_at_seatimes.com |
| Seattle, WA 98111    Packet:  KG7JE_at_N6EQZ.WA       |
+----------------------------------------------------+

All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Thu Jun 22 1995 - 00:00:00 CEST