SQL Codes › SQL Return Codes -1 through -999 › -156 - VIEW xxx WITH CHECK OPTION VIOLATION

-156 - VIEW xxx WITH CHECK OPTION VIOLATION

Reason:

You attempted to insert or update a row using a view, or one of its dependents, that was defined with the WITH CHECK OPTION. The row does not satisfy the view definition or dependent definitions that are being checked.

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

Action:

Ensure that the row satisfies all view definitions being checked or change the definition of the view(s).