SQL Server Transact Basic to Expert - Query to refresh a View DefinitionKarthikeyan Anbarasan15yPublished Jun 9, 2011, 12:00 AMUpdated Jun 9, 2011, 7:54 AM3k00Reactions×25BlogThis blog show how to query and refresh a view definition using the query analyerSyntax:Exec sp_refreshview 'Schema.ViewName'Example:EXEC sp_refreshview 'dbo.vemptable'CommentsJoin the conversation! Your thoughts help the community grow.Sign in to leave a commentIt is the same account you read, post and publish with — and you will come straight back to this page.Sign inCreate an account
Join the conversation! Your thoughts help the community grow.