Re: Disable constraints ?

From: J. K <cljlk_at_hotmail.com>
Date: Tue, 12 Jan 1999 15:28:51 -0500
Message-ID: <369BB083.E687678E@hotmail.com>

ALTER TABLE table_name DISABLE CONSTRAINT constraint_name CASCADE; If the constraint_name is an unique or primary key , you must specify CASCADE to disable the unique or primary key constraint.

ps. my Oracle version is 7.3.4.

James Petts wrote:

> On 11 Jan 1999 12:56:58 GMT, "Oliver Guillén Pérez"
> <oguillen_at_corp.infodisc.es> wrote:
>
> >Can I disable a database constraint ?
>
> ALTER TABLE tablename DISABLE CONSTRAINT constraintname;
>
> James Petts
Received on Tue Jan 12 1999 - 14:28:51 CST