SQL Server updates all views in batches after modifying the table structure

 

We often encounter this situation when using sqlserver. When the structure of a table is modified, the related views are incorrect.ProgramTherefore, there is a stored procedure.

  Create procedure refreshallview as <br/> declare mycursor cursor <br/> for select name from DBO. sysobjects where objectproperty (ID, N 'isview') = 1 and (not name in ('sysconstraints', 'syssegances ')) </P> <p> declare @ name varchar (40) <br/> open mycursor </P> <p> fetch next from mycursor into @ name <br/> while (@ fetch_status <>-1) <br/> begin <br/> If (@ fetch_status <>-2) <br/> begin <br/> exec sp_refreshview @ name <br/> end <br/> fetch next from mycursor into @ name <br/> end </P> <p> close mycursor <br/> deallocate mycursor <br/>

 

Original article:Http://www.cnblogs.com/yashen/archive/2004/12/23/81000.html