Skip to content

Instantly share code, notes, and snippets.

@pavankjadda

pavankjadda/Refresh all SQL Server views.md

Created June 7, 2021 16:20
Show Gist options
  • Save pavankjadda/4f9081acf799eca628b3f9c7b85a10ab to your computer and use it in GitHub Desktop.
Save pavankjadda/4f9081acf799eca628b3f9c7b85a10ab to your computer and use it in GitHub Desktop.
Download ZIP
Refresh all SQL Server views
Raw
Refresh all SQL Server views.md 
USE DATABASE_NAME
GO
DECLARE @sqlcmd NVARCHAR(MAX) = ''
SELECT @sqlcmd = @sqlcmd +  'EXEC sp_refreshview ''' + name + ''';' +
                 ''
FROM sys.objects AS so WHERE so.type = 'V'

SELECT @sqlcmd

EXEC(@sqlcmd)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment