Skip to content
Advertisement

SQL Views “WITH CASCADE CHECK OPTION” Behaivor?

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

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