-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