This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFF279.602FE760
Content-Type: text/plain;
charset="iso-8859-1"
set constraints constraint_name disabled;
then when done
set constraints constraint_name enabled;
-----Original Message-----
From: Joerg Spilker [mailto:js@jetsys.de]
Sent: Thursday, July 20, 2000 8:43 AM
To: informix-list@iiug.org
Subject: How to temporarily disable referential constraints on a table
Hello,
can i disable referential constraints on a database (or better, on
some specific table)? I only can imagine the way of dropping all
constraints, doing my database work and then creating the constraints
from scratch.
Greetings, Joerg Spilker
------_=_NextPart_001_01BFF279.602FE760
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2651.75">
<TITLE>RE: How to temporarily disable referential constraints on a table</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>set constraints constraint_name disabled;</FONT>
</P>
<P><FONT SIZE=2>then when done</FONT>
</P>
<P><FONT SIZE=2>set constraints constraint_name enabled;</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Joerg Spilker [<A HREF="mailto:js@jetsys.de">mailto:js@jetsys.de</A>]</FONT>
<BR><FONT SIZE=2>Sent: Thursday, July 20, 2000 8:43 AM</FONT>
<BR><FONT SIZE=2>To: informix-list@iiug.org</FONT>
<BR><FONT SIZE=2>Subject: How to temporarily disable referential constraints on a table</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hello,</FONT>
</P>
<P><FONT SIZE=2>can i disable referential constraints on a database (or better, on</FONT>
<BR><FONT SIZE=2>some specific table)? I only can imagine the way of dropping all</FONT>
<BR><FONT SIZE=2>constraints, doing my database work and then creating the constraints</FONT>
<BR><FONT SIZE=2>from scratch.</FONT>
</P>
<P><FONT SIZE=2>Greetings, Joerg Spilker</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01BFF279.602FE760--