MSSQL - 변경된 객체에 종속성이 있는 모든 뷰 업데이트

update all views that have dependencies on a changed object

--https://learn.microsoft.com/ko-kr/sql/relational-databases/system-stored-procedures/sp-refreshview-transact-sql?view=sql-server-ver16

SELECT DISTINCT 'EXEC sp_refreshview ''' + name + '''' 
FROM sys.objects so INNER JOIN sys.sql_dependencies sd 
ON so.object_id = sd.object_id 
WHERE type = 'V' 
AND sd.referenced_major_id = object_id('OBJECT_NAME')