SQL View "WITH CASCADE CHECK OPTION"行为？

Question

我找不到关于此的任何引用资料或文档。

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

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

如果在 View 2 上执行 UPDATE/INSERT，条件子句是否为 x = 1 AND y = 1？

Answer 1

好的，也许看看

WITH CASCADED CHECK OPTION它是 example

和

Defining Views

看起来 WITH CASCADE 选项确实强制执行所有 View 标准。