• 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/