create procedure dbo.proc_refreshview
as
begin
declare @viewname varchar(100)
declare cur_view cursor for select [name] from sysobjects where [type]='v'
open cur_view
fetch next from cur_view into @viewname
while(@@fetch_status=0)
begin
exec sp_refreshview @viewname
fetch next from cur_view into @viewname
end
close cur_view
deallocate cur_view
end
![[转]数据库物化视图刷新SQL命令和查询被delete掉的数据](https://www.kunjuke.com/file/css/thumb/8.jpg/280-180.jpg)
