Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: 'with check option' constraint

Re: 'with check option' constraint

From: Tony Rogerson <tonyrogerson_at_torver.net>
Date: Tue, 22 Nov 2005 09:29:03 -0000
Message-ID: <dluo34$s7a$1$8302bc10@news.demon.co.uk>


you could probably do something with an instead of trigger, depends what you are doing.

-- 
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"Carl Federl" <cfederl_at_yahoo.com> wrote in message 
news: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 Tue Nov 22 2005 - 03:29:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US