时间: 2021-08-13 作者:daque
/* 革新数据库视图.sql */ declare @vname sysname 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