declare refresh_cursor cursor for select name from sysobjects where xtype = 'v' order by crdate for read only open refresh_cursor
fetch next from refresh_cursor into @vname while @@fetch_status = 0 begin --刷新指定視圖的元數據。由于視圖所依賴的基礎對象的更改，視圖的持久元數據會過期。 exec sp_refreshview @vname print '視圖' + @vname + '已更新' fetch next from refresh_cursor into @vname end close refresh_cursor deallocate refresh_cursor
