Script to Refresh All Views in a SQL Server Database
Hi guys,
Views need to be refreshed if the underlying tables change at all. You shouldn’t have to run sp_refreshview for altering a view. Only for altering its underlying tables.
The following T-SQL script can be used to refresh all view inside a database:
Continue a ler »Script to Refresh All Views in a SQL Server Database