Last week i read a comment or a blog somewhere (i can’t remember it anymore but please let me know so i can credit!), that a select * in a view gets a full definition under the covers and doesn’t get updated when the underlying table is updated.
So, i decided to take that for a test, see what i can reproduce.
Spoilers: it doesn’t. Click through for the proof, as well as what does update a view’s definition.