June 7, 2012

sp_refreshview (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_refreshview(nvarchar @viewname)

MetaData:

 create procedure sys.sp_refreshview  
@viewname nvarchar(776)
as
declare @ret int
exec @ret = sys.sp_refreshsqlmodule_internal @viewname, N'OBJECT', 1 -- viewonly
return @ret

No comments:

Post a Comment

Total Pageviews