Re: 'with check option' constraint

From: Carl Federl <>
Date: 22 Nov 2005 06:34:46 -0800
Message-ID: <>

-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

Original text of this message