DECLARE @RefreshViews VARCHAR(MAX) = ''
SELECT @RefreshViews = @RefreshViews
+ 'EXEC sp_refreshview N''[' + TABLE_SCHEMA + '].[' + TABLE_NAME + ']''; '
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'VIEW'
EXEC (@RefreshViews)
