Re: 'with check option' constraint
From: -CELKO- <jcelko212_at_earthlink.net>
Date: 21 Nov 2005 16:39:30 -0800
Message-ID: <1132619970.618599.260300_at_g49g2000cwa.googlegroups.com>
Date: 21 Nov 2005 16:39:30 -0800
Message-ID: <1132619970.618599.260300_at_g49g2000cwa.googlegroups.com>
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. Received on Tue Nov 22 2005 - 01:39:30 CET