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?
asked 30 Aug '11, 04:48
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.
answered 30 Aug '11, 09:07