The sp_refreshview stored
procedure allows you to update the metadata of a view.
The syntax of this
procedure is:
sp_refreshview
[ @viewname= ] 'viewname'Here is
an example that executes this procedure:
USE NORTHWND;
GO
sp_refreshview N'Invoices';
GO