FilesExpand file tree

 master

/

SSDB.Script_Refresh_Views.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

10 lines (10 loc) · 359 Bytes

 master

/

SSDB.Script_Refresh_Views.sql

Copy path

Top

File metadata and controls

• Code
• Blame

10 lines (10 loc) · 359 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

SELECT DISTINCT

IndividualScript = 'EXEC sp_refreshview ''' + sc.name + '.' + so.name + ''''

FROM

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

1=1

AND so.type = 'V'

--AND OBJECT_NAME(sed.referenced_major_id) LIKE 'MyTable%'