Refreshing database views

View | data | database | refresh
/*
Refreshes the database view. sql
*/
DECLARE @vName sysname

DECLARE refresh_cursor Cursor FOR
SELECT Name from sysobjects WHERE xtype = ' V ' ORDER by crdate
For READ only
OPEN Refresh_cursor

FETCH NEXT from Refresh_cursor
Into @vName
While @ @FETCH_STATUS = 0
BEGIN
--Refreshes the metadata for the specified view. The persisted metadata for the view expires because of changes to the underlying object on which the view depends.
EXEC sp_refreshview @vName
PRINT ' view ' + @vName + ' updated '
FETCH NEXT from Refresh_cursor
Into @vName
End
Close Refresh_cursor
Deallocate refresh_cursor