Hi Hugo,

according to another QOD i.e view 5

there was condition that if a add a new column to the table (previously there were 5 columns) and didnt refresh the view then view return only 5 rows. It will return 6 column when we alter or refresh he view.

You told that view do not get effect untill we refresh it or alter.

so why in this question if we drop a column n thn do SELECT * FROM VOrder_Details,

in this condition also 5 columns should get return as view not altered nor refereshed.

I am confused with view behaviour. :w00t:

can you plz explain ?