Which materialized view cannot be automatically invalidated?

[#1]

I tried adding a column to a table which is used in a materialized view and received the error

Cannot drop or modify object '%1' because at least one other object ( %2 '%3') depends upon it

In the remarks it says that this is expected for "...a materialized view, that cannot be automatically invalidated." So, what are the criterias which prevent a materialized view from being automatically invalidated?

[Former Member · Accepted solution]

SQL Anywhere does not have a mechanism for automatically invalidating/re-materializing any materialized view when an underlying base table is modified. So it's not a question of which materialized views can or cannot be automatically invalidated; none of them can.

SQL Anywhere does, however, have the ability to automatically invalidate and re-establish ordinary views.