SqlServer刷新所有视图

CREATE PROCEDURE RefreshAllView AS DECLARE MyCursor CURSOR FOR select Name from dbo.sysobjects where OBJECTPROPERTY(id, N‘IsView‘) = 1 and (not name in (‘sysconstraints‘,‘syssegments‘))   DECLARE @name varchar(40) OPEN MyCursor   FETCH NEXT FROM MyCursor INTO @name WHILE (@@fetch_status <> -1) BEGIN  IF (@@fetch_status <> -2)  begin  exec sp_refreshview @name  end  FETCH NEXT FROM MyCursor INTO @name END   CLOSE MyCursor DEALLOCATE MyCursor