Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
V0137:
The specification states the following:
-
Subclause 11.32, "<view definition>": <view definition> ::= CREATE [ RECURSIVE ] VIEW <table name> <view specification> AS <query expression> [ WITH [ <levels clause> ] CHECK OPTION ] ... <levels clause> ::= CASCADED | LOCAL ... Conformance Rules Without Feature F751, "View CHECK enhancements", conforming SQL language shall not contain a <levels clause>. ... Without Feature F751, "View CHECK enhancements", conforming SQL language shall not contain <view definition> that contains a <query expression> that contains a <query expression> and contains WITH CHECK OPTION.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL partially supports this feature. The CASCADED and LOCAL keywords are not supported, but the WITH CHECK OPTION clause is supported by Transact-SQL.