Hi Hugo,
Ya i got the answer now..
So if a column is dropped from a base table which is using in view then it will throw an error..
but if after deleting a column if we add another column and without refreshing the view if we do Select query then it will show 5 columns and data will be wierd.
Right now?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/