RE: How to temporarily disable referential constraints on a table
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--