Re: 'with check option' constraint

From: Carl Federl <cfederl_at_yahoo.com>
Date: 21 Nov 2005 14:00:15 -0800
Message-ID: <1132610415.581490.122750_at_g44g2000cwa.googlegroups.com>

Oracle, Ocelot, and SQL Anywhere support defering check constraints until commit.

Definitely not supported by DB2 or MS SQL Server.

MS SQL Server does allow disabling a constraint, but the disabling applies to all connections and is not automatically re-enabled on commit. Received on Mon Nov 21 2005 - 23:00:15 CET

This message: [ Message body ]
Next message: Carl Federl: "Re: Using the catalogue"
Previous message: Gene Wirchenko: "Re: So what's null then if it's not nothing?"
In reply to: x: "'with check option' constraint"
Next in thread: Tony Rogerson: "Re: 'with check option' constraint"
Reply: Tony Rogerson: "Re: 'with check option' constraint"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message