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: Carl Federl <cfederl_at_yahoo.com>
Date: 22 Nov 2005 06:34:46 -0800
Message-ID: <1132670086.138307.189940@g44g2000cwa.googlegroups.com>

-CELKO- wrote:
> The WITH CHECK OPTION is not a constraint; it is part of the
> declaration of a VIEW. Deferring it would be a nightmare. Do you have
> a copy of SQL FOR SMARTIES? I have a section on nested VIEWs with
> various WITH CHECK OPTION [CASCADE] combinations. It is very
> complicated.

Quite correct, as I confused "CHECK CONSTRAINTS" with "WITH CHECK OPTION" My prior post applies to "CHECK CONSTRAINTS" and does not apply to "WITH CHECK OPTION" Received on Tue Nov 22 2005 - 08:34:46 CST

Original text of this message

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