Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (T-Z)

 

Triggers cannot be created on materialized view '%1'

Error constant SQLE_INVALID_TRIGGER_MATVIEW
ODBC 2 State 42000
ODBC 3 State ERROR
Parameter 1 Name of the materialized view
Severity 14
SQLCODE –1134
SQLSTATE 42W3D
Sybase error code 13379
Probable cause

You attempted to create a trigger on a materialized view. A materialized view is not a valid target for a trigger.