Rebuilding and Compiling All Views in SQL Server
Hello to everyone,
In this article, I will try to give information about rebuilding and compiling all Views in SQL Server.
In SQL Server you may want to rebuild and compile all Views in some cases.
You can easily do this using the code below.
DECLARE @SQL VARCHAR(MAX) = ''; SELECT @SQL = @SQL + 'print ''Refreshing --> ' + name + ''' EXEC sp_refreshview ' + name + '; ' FROM sysobjects WHERE type = 'V' AND name LIKE 'vw_%'; --SELECT @SQL --You can remove the comment line to check. EXEC (@SQL);
Good luck to everyone in business and life.