刷新SqlServer所有视图【存储过程】

摘自：http://www.cnblogs.com/yashen/archive/2004/12/23/81000.html

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

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