-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