Sunday 3 February 2013

Revision : sp_refreshview

For views that do not use WITH SCHEMABINDING, sp_refreshview should be run when the objects underlying the view are changed.

Usage :
exec sp_refreshview 'dbo.myView'

MSDN : sp_refreshview

No comments: