Question Re: Which materialized view cannot be automatically invalidated? in Technology Q&A

Which materialized view cannot be automatically invalidated?

MCMartin — Tue, 30 Aug 2011 04:48:09 GMT

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?

Re: Which materialized view cannot be automatically invalidated?

Former Member — Tue, 30 Aug 2011 09:07:16 GMT

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.