user479786 user479786 - 1 month ago 10
SQL Question

SQL Views "WITH CASCADE CHECK OPTION" Behaivor?

I can't find any reference, or documentation on this.

CREATE VIEW view1 AS SELECT * FROM tbl WHERE x = 1;

CREATE VIEW view2 AS SELECT * FROM view1 WHERE y = 1 WITH CASCADE CHECK OPTION;


Does the condition clause read
x = 1 AND y = 1
in case of
UPDATE
/
INSERT
on view2?

Answer

OK, so maybe have a look at

WITH CASCADED CHECK OPTION

and

Defining Views

It would seem that the WITH CASCADE option does enforce all view criteria.