Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL

6.7. WITH CHECK OPTION Clause

If WITH CHECK OPTION is specified, the viewed table has to be updatable. This is actually a fast way to check how your particular SQL implementation handles updatable VIEWs. Try to create a version of the VIEW in question using the WITH CHECK OPTION and see if your product will allow you to create it. The WITH CHECK OPTION is part of the SQL-89 standard, which was extended in Standard SQL by adding an optional <levels clause>. CASCADED is implicit if an explicit LEVEL clause is not given. Consider a VIEW defined as

CREATE VIEW V1
AS SELECT *
     FROM Foobar
    WHERE coll = 'A';

and now UPDATE it with

UPDATE V1 SET coll = 'B';

The UPDATE will take place without any trouble, but the rows that were previously seen now disappear ...