WITH CHECK OPTION

Description

Specifies the constraint that every row that is inserted or updated through the view must conform to the definition of the view. A row that does not conform to the definition of the view is a row that does not satisfy the search conditions of the view.

Click here to navigate to the IBM DB2 docs page for this syntax.

WITH CHECK OPTION is not supported in Snowflake.

Grammar Syntax

Sample Source Patterns

IBM DB2

Code 1

CREATE VIEW TestTableId2 AS Select * from TestTableId1 WITH CASCADED CHECK OPTION;

Snowflake

Code 1

CREATE VIEW PUBLIC.TestTableId2
AS Select * from TestTableId1
-- ** MSC-ERROR - MSCEWI5005 - MANIPULATION OF DATA IN VIEWS IS NOT SUPPORTED. **
--                              WITH CASCADED CHECK OPTION
                                                        ;

Related EWIs

1. MSCEWI5005: MANIPULATION OF DATA IN VIEWS IS NOT SUPPORTED