Refresh View

Working with applications that to alter the tables in the db there is often the problem to change the views in which the tables themselves are involved, this does not happen automatically.

Example, we have a view that takes in all fields of the table member (*), though in this table add or remove a column and you try to run the view we get an error, the quickest way to address and execute code via a refresh the view itself:

EXEC sp_refreshview viewName

simple but effective!