Skip to content
Advertisement

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?

Advertisement

Answer

OK, so maybe have a look at

WITH CASCADED CHECK OPTION and it’s example

and

Defining Views

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

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement