Sunbelt Computer Software

PL/B Language Development and Support

Home
About
Blog
Products
Forum
Support
Contact

TSQL-Scripts/SSDB.Script_Refresh_Views.sql at master · SQL-Server-projects/TSQL-Scripts · GitHub

10 lines (10 loc) · 359 Bytes

SELECT DISTINCT 
	IndividualScript = 'EXEC sp_refreshview ''' + sc.name + '.' + so.name + ''''
	sys.objects AS so 
	INNER JOIN sys.schemas sc ON sc.schema_id = so.schema_id
	INNER JOIN sys.sql_dependencies AS sed ON so.object_id = sed.object_id
WHERE       
	AND so.type = 'V' 
	--AND OBJECT_NAME(sed.referenced_major_id) LIKE 'MyTable%'

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

FilesExpand file tree

SSDB.Script_Refresh_Views.sql

Latest commit

History

SSDB.Script_Refresh_Views.sql

File metadata and controls