Error 1125

"Conflicting INSTEAD OF trigger and WITH CHECK OPTION on view '%1'"

Item Description

SQLCode

-1125L

Constant

CHECK_TRIGGER_CONFLICT

SQLState

42W39

ODBC 2 State

42000

ODBC 3 State

42000

Sybase Error Code

2797

Severity Code

15

Parameter 1

Name of the view with an INSTEAD OF trigger

Probable cause

You attempted an operation that involves a WITH CHECK OPTION clause that conflicts with an INSTEAD OF trigger. A view defined with the WITH CHECK OPTION clause cannot refer to a view (possibly nested) with an INSTEAD OF trigger.


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com