SQL Codes › SQL Return Codes -1 through -999 › -111 - THE VIEW IS NOT UPDATABLE BECAUSE IT CONTAINS A SUBQUERY

-111 - THE VIEW IS NOT UPDATABLE BECAUSE IT CONTAINS A SUBQUERY

Reason:

You cannot create a view with both a subquery and WITH CHECK OPTION.

The SQLSTATE that equates to this SQL return code is 42807.

Action:

Remove one or the other.