-20179 THE INSTEAD OF TRIGGER CANNOT BE CREATED BECAUSE THE VIEW `view-name` IS DEFINED USING THE WITH CHECK OPTION

Explanation
 An INSTEAD OF trigger cannot be defined on a symmetric
view, which is a view defined using WITH CHECK OPTION. It also cannot
be defined on a view on which a symmetric view has been defined directly
or indirectly. The view view-name might be the
target view of the INSTEAD OF trigger, or it might be a view that
depends directly or indirectly on the target view of the trigger.

System action
 The statement cannot be processed. The
INSTEAD OF trigger was not created.

Programmer response
 The INSTEAD OF trigger cannot be defined
on the view unless the symmetric view is replaced by a view that is
not symmetric. The view has to be dropped and re-created in order
to allow an INSTEAD OF trigger.

SQLSTATE
 428FQ

-20179 THE INSTEAD OF TRIGGER CANNOT BE CREATED BECAUSE THE VIEW view-name IS DEFINED USING THE WITH CHECK OPTION

Explanation

System action

Programmer response

SQLSTATE

-20179 THE INSTEAD OF TRIGGER CANNOT BE CREATED BECAUSE THE VIEW `view-name` IS DEFINED USING THE WITH CHECK OPTION