Dynamically Refreshing a View in SQL SERVER

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