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

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 MyCursorFETCH NEXT FROM MyCursor INTO @name WHILE (@@fetch_status <> -1) BEGINIF (@@fetch_status <> -2)beginexec sp_refreshview @nameendFETCH NEXT FROM MyCursor INTO @name ENDCLOSE MyCursor DEALLOCATE MyCursor

　　

轉(zhuǎn)載于:https://www.cnblogs.com/Jaryleely/p/refreshView.html

總結(jié)

以上是生活随笔為你收集整理的刷新SqlServer所有视图【存储过程】的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。