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_at_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 - 15:34:46 CET

This message: [ Message body ]
Next message: amado.alves_at_netcabo.pt: "Re: Implementing a graph algebra"
Previous message: N. Shamsundar: "Re: So what's null then if it's not nothing?"
Maybe in reply to: x: "'with check option' constraint"
In reply to -CELKO-: "Re: 'with check option' constraint"
Next in thread: x: "Re: 'with check option' constraint"
Reply: x: "Re: 'with check option' constraint"

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

Original text of this message