首页 > 代码库 > SqlServer刷新所有视图

SqlServer刷新所有视图

2024-08-09 07:11:42   219人阅读

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

SqlServer刷新所有视图


联系
我们