How do I create a stored procedure that calls sp_refreshview for each view in the database?
- by Allrameest
Today I run this
select 'exec sp_refreshview N''['+table_schema+'].['+table_name+']'''
from information_schema.tables
where table_type = 'view'
This generates a lot of: exec sp_refreshview N'[SCHEMA].[TABLE]'. I then copy the result to the query editor window and run all those execs.
How do I do this all at once?
I would like to have a stored procedure called something like dev.RefreshAllViews which I can execute to do this...
