SQL Server Transact Basic to Expert - Query to refresh a View Definition as module

Karthikeyan Anbarasan
13y
2.9k
0
0

Blog

This blog show how to query and refresh a view definition using the query analyer and its not only used for Views but also can be used for Stored procedures, functions etc

Syntax:

EXEC sys.sp_refreshsqlmodule @name = 'Schema.ViewName'

Example:

EXEC sys.sp_refreshsqlmodule @name = 'dbo.vemptable'