Dropping constraints

From: <man_at_sjoki.uta.fi>
Date: Sun, 11 Jul 1999 11:41:18 GMT
Message-ID: <7m9vsu$s74$1@nnrp1.deja.com>

Hello,

I'd like to disable a "NOT NULL" constraint using a simple script. The problem is that it is difficult to track the name of the constraint from the user constraints table, since the search_condition column is LONG.

An example: this is what I'd like to do: alter table DOCUMENTS drop constraint (select constraint_name from user_constraints where search_condition like '%STATUS_ID NOT NULL%');

or:

delete from user_constraints where table_name='DOCUMNENTS' and search_condition like '%STATUS_ID NOT NULL%'

Any help greatly appreciated and sorry if this is a FAQ.

-man

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sun Jul 11 1999 - 06:41:18 CDT