You create a view by using the following code:
Several months after you create the view, users report that the view has started to return
unexpected results.
You discover that the design of Table2 was modified since you created the view.
You need to ensure that the view returns the correct results.
Which code segment should you run?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
https://msdn.microsoft.com/en-us/library/ms187821.aspx
sp_refreshview [ @viewname = ] ‘viewname’