When I declare a view as
CREATE VIEW myView AS SELECT * FROM MyTable
and ALTER TABLE MyTable lateron by adding columns, it seems that v10 and above adapt the view automatically, i.e. the view contains the added table columns, too, though I haven't used ALTER VIEW on that view.
Is that by design?
(With v8, I surely have to call ALTER VIEW explicitly to include the newly added columns.)
Tracking view dependencies, and automatically re-compiling views due to base table changes, was a v10 feature.
answered 14 Jun '12, 12:41