Update View Definition

There could be a situation when you update the underlying base tables but view definitions are not updated. In order to update the view metadata for the specified non-schemabound view, use the following:

sp_refreshview [ @viewname = ] 'viewname'